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 “honcho” with Change Limit: [1] [2] [3]

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

211 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
honcho1438938(None) 
concho134414261concho
honchos15369571honchos
poncho133310121poncho
ancho104515302_ancho
broncho14206462broncho
conch124620072conch_
concha134213282concha
conchos144313962conchos
conchs134714902conchs
conchy163710222conchy
honchoed1745732honchoed
hooch135813702hooch_
hotch136214732hotch_
hunch136416212hunch_
ponchos143410702ponchos
rancho114310852rancho
rhonchi1542502rhonchi
anchor113911973_anchor
anchos114214893_anchos
banco94019393banc_o
bench125619503bench_
boche124216953bo_che
boho96923323bo__ho
bongo85720943bon_go
bonito8313433bonito
bonobo1037143bonobo
boocoo1039003boocoo
botch126717453botch_
botchy16537823botchy
bronchi14176313bronchi
bronchos15206173bronchos
bronco10179493bronc_o
bunch125118603bunch_
bunchy16437463bunchy
bunco94616083bunc_o
cancha134411613cancha
chinch163911243chinch_
chinchy20335523chinchy
chowchow2482063chowchow
cinch124516243cinch_
coach125919453coach_
coanchor1545253coanchor
coco87330603co_c_o
coho97524493co__ho
conchae143911643conchae
conchal144211593conchal
conchas144013313conchas
conches144019813conches
conchie143312683conchie
conchoid1688043conchoid
concur10411103concur
condo85322593con_do
congo85623133con_go
conto76027173con_to
cooch124916833cooch_
coocoo1069693coocoo
couch125320113couch_
douche124613223douche
dunch115316263dunch_
echo96615953__echo
finch135416973finch_
gaucho1256223gaucho
gonzo15310243gon_zo
gotcha1234633gotcha
hance105424153hanc_e
hances115621283hances
hatch135719593hatch_
haunch14377343haunch_
hence104920053henc_e
hencoop1443813hencoop
heuch135312333heuch_
heuchs14447923heuchs
hitch134515473hitch_
hobo97026083ho__bo
hock136031303ho_c_k
hocks144925493ho_cks
hocus104715203ho_cus
hoick145210683hoic_k
hoicks15378283hoicks
hollo84822163ho_llo
holloo94415253holloo
homo96126473ho__mo
hon67759383hon___
honan85319773hon_an
honans94814503honans
honchoing1844873honchoing
honda9414983hon_da
hondas10313353hondas
hondle103914523hondle
hone77549323hon__e
honed95332263hon_ed
honer85332093hon_er
honers94324973honers
hones88144493hon_es
honest94822423honest
honey115629913hon_ey
honeys124016083honeys
hong85833953hon__g
hongi96715873hon_gi
hongs95126203hon_gs
honied104818393honied
honing103421513honing
honk116931193hon__k
honked144517913honked
honker134117463honker
honkey165113823honkey
honkie133011673honkie
honks125124523hon_ks
honky156218523hon_ky
honor85718623hon_or
honors94816793honors
honour94710863honour
hons77350783hon__s
hooches153812523hooches
hoochie1537803hoochie
hoodoo10109983hoodoo
hoopoo1198753hoopoo
hootch14386413hootch_
horah117922053horah_
horahs126313873horahs
hornito1047073hornito
hotched163610923hotched
hotches153814363hotches
hotchpot1844123hotchpot
hotshot1358343hotshot
hunched163710493hunched
hunches153913463hunches
hunh106323733hun_h_
hutch135414093hutch_
inch95420823_inch_
jocko184210453jo_cko
junco144612203junc_o
kench145513923kench_
loach105116363loach_
loch95527133lo_ch_
lochs106715513lo_chs
loco67030743lo_c_o
louche115212663louche
lunch104917243lunch_
lynch13468983lynch_
macho126120153_macho
manche133515103manche
mocha1249923mo_cha
mondo85721233mon_do
mongo810122413mon_go
mono66036723mon__o
month104818423month_
months113812933months
mooch125313613mooch_
morpho13158443morpho
mouch124715803mouch_
mucho125013443_mucho
munch124917103munch_
nacho105414383_nacho
nonce75719823nonc_e
nonces84418833nonces
noncom1039683noncom
nonego737013nonego
notch105613323notch_
nuncio837973nuncio
oho66534383_o__ho
once65423083_onc_e
oncet74626543_oncet
ono36838033_on__o
onto46127663_on_to
ortho8312293_ortho
ouch95724633_ouch_
phono104917023phon__o
pinch125619303pinch_
poach124917863poach_
poachy16388963poachy
poco86826153po_c_o
ponce95222513ponc_e
ponced114314813ponced
ponces104720843ponces
ponchoed1646133ponchoed
pooch124815303pooch_
porch125918623porch_
pouch124617083pouch_
pouchy16538663pouchy
psycho1674533psycho
punch125118423punch_
punchy16398523punchy
ranch105019793ranch_
ranchos123911393ranchos
reecho11318653reecho
rhonchal1642683rhonchal
rhonchus1642063rhonchus
roach105717003roach_
rondo65218373ron_do
rotch105815933rotch_
rotche114311983rotche
rouche114714313rouche
socko115215113so_cko
sorgho10348713sorgho
synch135011793synch_
synchro1544543synchro
synchs14408453synchs
tench105620003tench_
tondo69718683ton_do
torch107420933torch_
torchon1237363torchon
torchy14549533torchy
touch106519393touch_
touche114916173touche
touchy145010503touchy
unco66021403_unc_o
vouch134611903vouch_
wench136214783wench_
winch135016663winch_

Search took 6 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 Filter1786911127160.390458182.1
2DLD Change Limit1127162115.22021593.1
3Display Results2112110.0603516.7
 (SQL Overall)1786912115.67031515.2
 
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.