Welcome!   |  Search Scrabble® Dictionary using DLD   |  Statistics   |  Compare any two Strings using DLD   |  Reference   |  Your IP

Dictionary Search Results using Damerau-Levenshtein distance in T-SQL

Here are the results of your fuzzy-string dictionary search for “psi” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

187 similar words found! Changes to Transform each Found Word to your word are shown as:
 remove a letter ~ replace a letter ~ swap two letters ~ _add a letter from your word
(Use the links in the Changes column to see more Transformation details.)

Found WordScrabble ScoreSearched PreviouslyFound PreviouslyChangesTo Transform to your Word
psi5662162(None) 
phi86524201phi
pi48145371p_i
pis56362041pis
poi57244661poi
psis68120341psis
pst57932511pst
si29149581_si
ahi68040232ahi
ai211288402_ai
ais39083582ais
ami56646812ami
ani37751182ani
apse67725382apse
apsis75718292apsis
as211083072as_
asci66519142asci
ash67944602ash
ask77130702ask
asp57235342asp
ass37844062ass
bi48046482_bi
bis56860672bis
chi86228652chi
cis57748042cis
dis46459902dis
dui46433382dui
es29048222es_
ess36030882ess
ghi77019882ghi
hi57947592_hi
his66359512his
is27048222is_
ism56322392ism
khi106318312khi
ki67537972_ki
kis78051492kis
koi77534762koi
lei36846382lei
li29948762_li
lis37162282lis
mi48249062_mi
mis58162632mis
nisi45823252nisi
obi57127732obi
oi29061492_oi
ops56641252ops_
opsin7613472opsin
os211359882os_
ose38147342ose
pa410456482p_a
pac79054082pac
pad68057332pad
padi76331792padi
pah88853592pah
paid75737492paid
paik105726802paik
pail66141832pail
pain65647242pain
pair66031512pair
pal56761672pal
pam77858392pam
pan58466452pan
pap76758402pap
par57467022par
pas58775742pas
pase65346862pase
pash95638132pash
pass65239952pass
past65959012past
pat58089462pat
paw87651172paw
pax127346852pax
pay88461182pay
pe47649032p_e
pea56657242pea
pec76744412pec
ped66751532ped
pee56066512pee
peg65843062peg
peh86740962peh
pein65834942pein
pen56558842pen
pep76447082pep
per56353092per
peri65636972peri
pes57259782pes
peso66925822peso
pest65555292pest
pet56477302pet
pew86442302pew
pfui9349792pfui
phis95724902phis
phiz186718842phiz
pht86030522pht
pia56848042pia
pic76046832pic
pie55457412pie
pig65744982pig
piki106520572piki
pili66130362pili
pin57066732pin
pip78051052pip
pish96127922pish
piso66727572piso
piss65033342piss
pit56471932pit
piu56639552piu
pix126437942pix
plie65127392plie
ply86323552ply
pod66351492pod
poh86740532poh
pois66539042pois
pol56449382pol
pom78249912pom
poo57757112poo
pop76252252pop
pose66441732pose
posh95427322posh
posit75833332posit
post67953362post
posy96028422posy
pot58078432pot
pow87147282pow
pox126140692pox
prig75924872prig
prim85132202prim
pro55837262pro
pry85728052pry
psoai7469922psoai
psst66118402psst
ptui64912482ptui
pub76037692pub
pud65836662pud
pug65337182pug
pul56138062pul
puli65527622puli
pun58846512pun
pup76339882pup
pur56840552pur
puri65931442puri
pus55547842pus
push95526622push
puss64830132puss
put55759072put
pya87023752pya
pye86432502pye
pyic116915822pyic
pyin96823232pyin
pyx157817012pyx
qi116526912_qi
qis126934392qis
rai37658222rai
rei35647252rei
sei36048932sei
sh56828522_sh
sib56850322_sib
sic55847882_sic
sim56553152_sim
sin36265902_sin
sip57656022_sip
sir35746682_sir
sis37360552_sis
sit35877762_sit
six105339752_six
ski74925702ski
so28855442_so
spa55730812spa
spic85227432spic
spik105419712spik
spin66231302spin
spit65545082spit
spiv95917792spiv
spy86023742spy
sri35634002sri
ti28448302_ti
tis37056652tis
tsk75814732tsk
tui37034022tui
ups55629052ups_
us26937432us_
use36835162use
vis66747622vis
wis66552342wis
xi98128172_xi
xis106935342xis

Search took 2 seconds overall (including website activity, plus SQL activity in the following phases):

  1. Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
  2. DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
  3. Display Results: Return the results, with similar words marked up to highlight differences.
SeqSearch PhaseWords CheckedWords MatchedSecondsWords Per Sec
1Length Filter178691140840.796224486.2
2DLD Change Limit140841871.01613862.2
3Display Results1871870.0802337.5
 (SQL Overall)1786911871.89294445.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  Published At: SQLServerCentral (with Source Code)  |  Presented At: SQLSaturday #144  |  Demonstrated For: Sacramento SQL Server User Group  |  Developed For: Repo Remarketing  |  Running On: Microsoft SQL 2014 RTM Standard on Server 2012 R2 (also successfully run on SQL 2012 Web Edition, SQL Express 2008-2008R2, and SQL Server 2000-2005 Standard)  |  SQL Performance Monitoring By: Confio Ignite  |  American Scrabble® Dictionary From: Internet Scrabble Club  |  Scrabble® is a registered trademark. All intellectual property rights in and to the game are owned in the U.S.A and Canada by Hasbro Inc., and throughout the rest of the world by J.W. Spear & Sons Limited of Maidenhead, Berkshire, England, a subsidiary of Mattel Inc. Mattel and Spear are not affiliated with Hasbro. This site is not affiliated with Scrabble®, Mattel, Spear, or Hasbro in any way. This site is for entertainment and technical education purposes only.