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

307 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
yucch1541743(None) 
yecch15558091yecch
yucca12467441yucca
yuch125818531yu_ch
bunch125118602bunch
butch125416542butch
culch124512832culch
curch124415412curch
cutch125116192cutch
dunch115316262dunch
dutch114713822dutch
gulch113810602gulch
hunch136416212hunch
hutch135414092hutch
lunch104917242lunch
lurch104814632lurch
much115224032mu_ch
mulch124012972mulch
munch124917102munch
mutch125016172mutch
ouch95724632ou_ch
punch125118422punch
succah1336642succah
such96424812su_ch
yecchs16414952yecchs
yech127220532y_ech
yuca95716722yu_ca
yucas106013912yucas
yuccas13426552yuccas
yuck136423532yu_ck
yucks144717192yucks
yucky175411692yucky
aitch105216163aitch
arch98628443_arch
bacca111012183bacca
bach116131393_bach
batch124620103batch
beach124623893beach
beech124315503beech
belch124415503belch
bench125619503bench
birch124914023birch
bitch125017763bitch
bocce114313113bocce
bocci113512713bocci
botch126717453botch
brach126123303brach
brunch13329353brunch
buccal1248243buccal
buck125129903bu_ck
bucko134614023bucko
bucks134824293bucks
bumph144911983bumph
bunchy16437463bunchy
bunco94616083bunco
burgh115216033burgh
bush96630713bu_sh
catch125120373catch
church1636483church
cinch124516243cinch
clach124617823clach
clutch13367753clutch
coach125919453coach
cocci82812673cocci
conch124620073conch
cooch124916833cooch
couch125320113couch
crunch13349503crunch
crutch13408243crutch
cuish10313173cuish
cultch13385953cultch
ditch115015093ditch
ducal84816423ducal
ducat86225903ducat
duce76933503du_ce
duces86327473duces
duchy144310873duchy
duci76422623du_ci
duck115929173du_ck
ducks124823213ducks
ducky154216113ducky
duct75735463du_ct
ducts85319893ducts
duh77930383du__h
dunce86319263dunce
each95530583_each
epoch1248203epoch
etch95419143_etch
eunuch1154363eunuch
fetch134913473fetch
filch134813323filch
finch135416973finch
fitch134816873fitch
fuci95720313fu_ci
fuck134924633fu_ck
fucks144419253fucks
fucus105515893fucus
glunch1255353glunch
grutch12285563grutch
guaco85012163guaco
guck114922533gu_ck
gucks123917303gucks
gursh94512333gursh
gush85424003gu_sh
hatch135719593hatch
haunch14377343haunch
heuch135312333heuch
hitch134515473hitch
hooch135813703hooch
hotch136214733hotch
huck135927633hu_ck
hucks144322173hucks
huh96432013hu__h
huic94818053huic_
humph155712213humph
hunh106323733hu_nh
hush105224113hu_sh
ich86227743__ich
inch95420823_inch
itch95619173_itch
juco134716203ju_co
jucos144111713jucos
juice14311323juice
juicy1738283juicy
junco144612203junco
kench145513923kench
ketch144912023ketch
laich105920713laich
larch105919793larch
latch104620463latch
launch11368063launch
leach105422523leach
lech96825443_lech
leech104913213leech
letch105215803letch
lich96230843_lich
loach105116363loach
loch95527133_loch
luce65132573lu_ce
luces75528433luces
lucid84314573lucid
luck105329823lu_ck
lucks115723563lucks
lucky145515013lucky
lucre76415523lucre
lush75327693lu_sh
lych126015763_lych
lynch13468983lynch
mach116134483_mach
march125622893march
match125621103match
mecca1139933mecca
merch125417963merch
milch124413373milch
mooch125313613mooch
mouch124715803mouch
mucho125013443mucho
mucid104115253mucid
mucin93116823mucin
muck125727853mu_ck
mucks134622643mucks
mucky165015253mucky
mucor94011943mucor
mucro94513723mucro
mucus94015743mucus
mulct93820083mulct
musca9311763musca
mush94929123mu_sh
musth105314783musth
natch105018223natch
nautch1144813nautch
notch105613323notch
nucha10229793nucha
nudzh1835133nudzh
orach105219233orach
ounce77019933ounce
ouph95618373ou_ph
parch125123003parch
patch125221223patch
paunch13369853paunch
peach125422493peach
pech116125453_pech
perch124518833perch
pinch125619303pinch
pitch125018413pitch
poach124917863poach
pooch124815303pooch
porch125918623porch
pouch124617083pouch
psych1554963psych
puce85127883pu_ce
puces94924633puces
puck124927943pu_ck
pucka133412803pucka
pucks134322103pucks
pugh106619233pu_gh
pujah17478543pujah
punchy16398523punchy
push95526623pu_sh
putsch1334933putsch
quack203812503quack
quaich2047693quaich
quash174512163quash
quench2036633quench
quiche2057903quiche
quick204311063quick
quitch2036413quitch
quoth173310353quoth
qursh174110843qursh
ranch105019793ranch
ratch104221363ratch
raunch11358433raunch
reach105123883reach
recce9514563recce
retch104818303retch
rich97025543_rich
roach105717003roach
rotch105815933rotch
ruche104216763ruche
ruck104728333ru_ck
rucks114422053rucks
rush76628183ru_sh
ruth76825993ru_th
sauch104918773sauch
sculch13226213sculch
scutch13247083scutch
secco9312423secco
smutch13205843smutch
stich104117923stich
stucco1044253stucco
subah106015213subah
succahs1435323succahs
succor1036623succor
succoth1445093succoth
suck106131733su_ck
sucks114523073sucks
sucky144415503sucky
sucre75019103sucre
sugh86423443su_gh
sulci7615053sulci
sumach135310113sumach
surah86823253surah
synch135011793synch
tach96132753_tach
teach105221123teach
tech95925443_tech
tench105620003tench
teuch105214853teuch
torch107420933torch
touch106519393touch
tuck104626573tu_ck
tucks114721123tucks
tusche1136783tusche
tush74523903tu_sh
ugh76520683_u_gh
uh57429853_u__h
unci65019463_unci
unco66021403_unco
vetch134411843vetch
vouch134611903vouch
vugh117115723vu_gh
watch135617063watch
welch134411493welch
wench136214783wench
which163910083which
wicca1247253wicca
wich125724743_wich
winch135016663winch
witch134517563witch
wych154011883_wych
yacht13417393yacht
yack135425973y_ack
yacks144419813yacks
yah99046353y__ah
yeah106725413y_eah
yechs136112583yechs
yechy16519083yechy
yeh97135773y__eh
yince105214253yince
yirth116513753yirth
yock135924613y_ock
yocks144418373yocks
yodh119916103y_odh
yogh116616143y_ogh
youth115315043youth
yuan76120013yu_an
yuans84613323yuans
yucked164013563yucked
yuga85615423yu_ga
yugas95012063yugas
yuk106725603yu__k
yukky14425213yukky
yuks116418023yu_ks
yulan8411493yulan
yule75725143yu_le
yules84521583yules
yum86132823yu__m
yummy15429153yummy
yup86031703yu__p
yupon10469483yupon
yuppy15487913yuppy
yups96121603yu_ps
yurt76435043yu_rt
yurta86014253yurta
yurts87216533yurts
yutz167519883yu_tz
zilch19438123zilch

Search took 5 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 Filter178691836670.436409841.7
2DLD Change Limit836673073.59623266.7
3Display Results3073070.0764039.5
 (SQL Overall)1786913074.10843498.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.