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

225 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
tho6743396(None) 
ho510258271_ho
mho86624621mho
oho66534381oho
rho65924831rho
tao38358951tao
the67436051the
thio77225411thio
thou76722211thou
thro77726421thro
thy97022911thy
to218858981t_o
too38965421too
two67925831two
who95526771who
abo59045962abo
ado49146872ado
ago48845522ago
ah513868792ah_
aha611246642aha
ahi68040232ahi
ahoy101919182ahoy
ahs68644822ahs
altho86312602altho
apo511142122apo
avo68936232avo
azo128233392azo
bio57846072bio
bo410957572_bo
boho96923322boho
boo58163662boo
bro56236602bro
chao95727312chao
chi86228652chi
chon96627792chon
chop116024922chop
chow125820992chow
coho97524492coho
coo59566362coo
dhow116614002dhow
do310155252_do
duo48536142duo
echo96615952echo
ego46726052ego
eh58339962eh_
eth66630982eth_
ethos85514192ethos
eths76619522eths
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
hot67776052_hot
how97252432_how
hoy97447912_hoy
jo99539602_jo
khi106318302khi
litho86513782litho
lo28053442_lo
loo38359822loo
mhos95517772mhos
mo49158482_mo
moo58460512moo
no29353242_no
noh66640642noh
noo37154042noo
nth66320592nth_
oh57447002oh_
ohm86523012ohm
ohs66232312ohs
ono36838032ono
ooh67637092ooh
ortho8312292ortho
otto45220642otto
oxo107322962oxo
phi86524202phi
phon95925382phon
phot95534352phot
pht86030522pht
poh86740532poh
poo57757112poo
pro55837262pro
rhos76319062rhos
sh56828522sh_
sha69837782sha
she66837692she
shh97121072shh
shmo95318092shmo
shod86225052shod
shoe75933432shoe
shog86025132shog
shoo75929882shoo
shop95629832shop
shot76150242shot
show106229182show
shy96728192shy
so28855442_so
ta211662452t_a
tab57460322tab
taco67031352taco
tad47959822tad
tae38267052tae
tag47259492tag
tahr75217152tahr
taj106442192taj
tam58663422tam
tan37167562tan
taos45541002taos
tap57663872tap
tar37570692tar
taro46846912taro
tas38477102tas
tat37690292tat
tau36856902tau
tav66043212tav
taw610155452taw
tax109449152tax
tea37353322tea
ted46446562ted
tee38366872tee
teg45741622teg
tel35647902tel
ten35856112ten
tet39274982tet
tew66640152tew
thae76825562thae
than76128772than
that75639322that
thaw107521312thaw
thee78039062thee
them97427042them
then78429692then
thew108226232thew
they107223752they
thin76732382thin
thiol87616042thiol
thir76420542thir
this76027382this
thole85620842thole
thong95014172thong
thorn85318702thorn
thoro86217872thoro
thorp104414262thorp
those85218142those
thous86017252thous
throb109816852throb
throe89321422throe
throw118719732throw
thru76818942thru
thud85613912thud
thug86415482thug
thus76721472thus
ti28448292t_i
tic56343462tic
tie36557532tie
til36350262til
tin36362172tin
tip56551222tip
tiro46832362tiro
tis37056642tis
tit36771042tit
tod49457072tod
toe310166852toe
tog410255042tog
tom514358052tom
ton310265102ton
took86531072took
tool46735682tool
toom66532932toom
toon47740632toon
toot45958882toot
top510560682top
topo66932402topo
tor39261682tor
toro48045682toro
tot38884772tot
tow610557362tow
toy69655192toy
toyo76925452toyo
trio45233342trio
trod57627952trod
trog57628212trog
trop66833302trop
trot46351312trot
trow78031422trow
troy77429682troy
try66529672try
tsk75814732tsk
tub55640032tub
tug45937402tug
tui37034022tui
tun35845192tun
tup56037542tup
tut36758092tut
tux105426572tux
twa67721642twa
twos76718022twos
tye65837442tye
typo95418122typo
tyro76622362tyro
udo49027302udo
uh57429852uh_
upo58925862upo
wha96422072wha
whoa106615202whoa
whom127018172whom
whop125520922whop
why126920012why
wo510447762_wo
woo66949802woo
yo59748552_yo
zoo126238912zoo

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.1231452772.4
2DLD Change Limit140842250.83016968.7
3Display Results2252250.0932419.4
 (SQL Overall)1786912251.046170832.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.