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

115 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
eunuch115436(None) 
eunuchs1272681eunuchs
bunch125118602bun_ch
dunch115316262dun_ch
hunch136416212hun_ch
lunch104917242lun_ch
munch124917102mun_ch
punch125118422pun_ch
avouch1434833avouch
bench125619503ben_ch
brunch13329353brun_ch
bunchy16437463bun_chy
bunco94616083bun_co
butch125416543bu_tch
cinch124516243cin_ch
conch124620073con_ch
couch125320113_couch
crouch133910203crouch
crunch13349503crun_ch
culch124512833cu_lch
cultch13385953cultch
curch124415413cu_rch
cutch125116193cu_tch
debauch15134423debauch
debouch15124253debouch
dunce86319263dun_ce
dutch114713823du_tch
each95530583e__ach
educe84313453e_duce
educt85017103e_duct
enact73525363e_nact
ennui537523ennu_i
ennuis636473ennuis
ennuye973753ennuye
enough1045763enough
enrich1138943enrich
enuf7323843e_nu_f
enure53520223e_nure
eparch13258423eparch
epoch1248203e_poch
eruct74022353e_ruct
etch95419143e__tch
eunuchism1651843eunuchism
eunuchoid1551893eunuchoid
exarch18196173exarch
finch135416973fin_ch
glunch1255353glun_ch
grouch12318473grouch
gulch113810603gu_lch
haunch14377343haun_ch
heuch135312333_heuch
hunh106323733hun__h
hutch135414093hu_tch
inch95420823_in_ch
junco144612203jun_co
kench145513923ken_ch
launch11368063laun_ch
lunacy1136843lunacy
lunula636173lunula
lunule638433lunule
lurch104814633lu_rch
lynch13468983lyn_ch
mensch13387103mensch
mouch124715803_mouch
much115224033__much
mulch124012973mu_lch
mutch125016173mu_tch
nonsuch1244683nonsuch
nubuck1434543nubuck
nucha10229793__nucha
ouch95724633__ouch
ounce77019933oun_ce
paunch13369853paun_ch
penuche1435943penuche
penuchi1444033penuchi
pinch125619303pin_ch
pouch124617083_pouch
punchy16398523pun_chy
punish111411503punish
punkah15347093punkah
putsch1334933putsch
quaich2047693quaich
quench2036633quench
quitch2036413quitch
qurush1835503qurush
ranch105019793ran_ch
raunch11358433raun_ch
retouch1235863retouch
runic73615773runic_
sauch104918773_sauch
sheuch14267043sheuch
slouch11438523slouch
snuck114411913_snuck
such96424813__such
sumach135310113sumach
sunnah9369353sunnah
sunup7313053sunu_p
sunups837263sunups
synch135011793syn_ch
tench105620003ten_ch
teuch105214853_teuch
touch106519393_touch
tunic74018223tunic_
tunica8379813tunica
tunics83811263tunics
unci65019463_un_ci
unco66021403_un_co
uncus74014983_uncus
uncut73219173_uncut
untuck1236403_untuck
vouch134611903_vouch
wench136214783wen_ch
winch135016663win_ch
yucch15417433yu_cch
yuch125818533__yuch

Search took 7 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.373479064.3
2DLD Change Limit1127161155.68619823.4
3Display Results1151150.0333484.8
 (SQL Overall)1786911156.09229332.1
 
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.