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 “rho” 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.

189 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
rho6592483(None) 
ho510258271_ho
mho86624621mho
oho66534381oho
rhos76319061rhos
tho67433961tho
who95526771who
abo59045962abo
ado49146872ado
ago48845522ago
ah513868792ah_
aha611246642aha
ahi68040232ahi
ahoy101919182ahoy
ahs68644822ahs
apo511142122apo
arco68331542arco
arvo76023432arvo
avo68936232avo
azo128233392azo
bio57846082bio
bo410957572_bo
boho96923322boho
boo58163662boo
brio65432492brio
bro56236602bro
broo65129822broo
chao95727312chao
chi86228652chi
chon96627792chon
chop116024922chop
chow125820992chow
coho97524492coho
coo59566362coo
dhow116614002dhow
do310155252_do
duo48536142duo
echo96615952echo
ego46726052ego
eh58339962eh_
ergo56420152ergo
foh98135892foh
fro65530642fro
ghi77019882ghi
go38748742_go
goo47754772goo
ha510259942_ha
hao67251122hao
he58151952_he
hi57947582_hi
hm78126732_hm
hob87550922_hob
hod76852462_hod
hoe67562722_hoe
hog78049062_hog
hon67759382_hon
hop87554592_hop
hos68364192_hos
hot67776062_hot
how97252432_how
hoy97447912_hoy
jo99539602_jo
khi106318302khi
lo28053442_lo
loo38359822loo
mhos95517772mhos
mo49158482_mo
moo58460512moo
no29353242_no
noh66640642noh
noo37154042noo
oh57447002oh_
ohm86523012ohm
ohs66232312ohs
ono36838032ono
ooh67637092ooh
ordo54622352ordo
ortho8312292ortho
orzo134516782orzo
oxo107322962oxo
phi86524202phi
phon95925382phon
phot95534362phot
pht86030522pht
poh86740532poh
poo57757112poo
prao66229022prao
pro55837262pro
rad47662002rad
rag45761322rag
rah68052402rah
rai37658222rai
raj105740222raj
ram56867272ram
ran38266622ran
rap56261962rap
ras37575392ras
rat37892742rat
rato45436972rato
raw67252252raw
rax108445722rax
ray66361992ray
re26153742r_e
reb55844962reb
rec55645462rec
red46755802red
redo56029362redo
ree37974072ree
ref66053292ref
reg46146492reg
rei35647252rei
rem56150042rem
rep55847802rep
repo66027542repo
res35565042res
ret35982832ret
rev65336622rev
rex105740992rex
rhea75017432rhea
rhino84614322rhino
rhomb12399802rhomb
rhus75114052rhus
ria36745502ria
rib56848032rib
rid46754622rid
rif65951562rif
rig46748122rig
rim56052272rim
rin36663182rin
riot45947212riot
rip56851302rip
rob56754302rob
roc520243252roc
rod47953892rod
roe36861082roe
rom59855632rom
rood56733002rood
roof75738832roof
rook85532032rook
room66235082room
root45655922root
rot37282952rot
roto45935052roto
row67453672row
rub56342822rub
rue35549262rue
rug46039152rug
rum56644642rum
run36244982run
rut35560522rut
rya67622012rya
rye66032542rye
ryot75528562ryot
sh56828522sh_
sha69837782sha
she66837692she
shh97121072shh
shmo95318102shmo
shod86225062shod
shoe75933442shoe
shog86025142shog
shoo75929892shoo
shop95629842shop
shot76150262shot
show106229192show
shy96728192shy
so28855442_so
tao38358952tao
the67436052the
thio77225412thio
thou76722212thou
thro77726422thro
thy97022912thy
to218858982_to
too38965422too
trio45233342trio
two67925832two
udo49027302udo
uh57429852uh_
upo58925862upo
wha96422072wha
whoa106615202whoa
whom127018182whom
whop125520922whop
why126920012why
wo510447762_wo
woo66949802woo
yo59748552_yo
zoo126238912zoo

Search took 1 second 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.0632836365.1
2DLD Change Limit140841890.37337758.7
3Display Results1891890.0335727.3
 (SQL Overall)1786911890.469381004.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  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.