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

497 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
zilch1943812(None) 
filch134813321filch
milch124413371milch
aitch105216162aitch
belch124415502belch
birch124914022birch
bitch125017762bitch
cinch124516242cinch
culch124512832culch
ditch115015092ditch
filth115015822filth
finch135416972finch
fitch134816872fitch
gulch113810602gulch
hitch134515472hitch
ich86227742_i_ch
inch95420822_inch
itch95619172_itch
lich96230842li_ch
mulch124012972mulch
pinch125619302pinch
pitch125018412pitch
rich97025542ri_ch
tilth85515362tilth
welch134411492welch
wich125724742wi_ch
wilco1039442wilco
winch135016662winch
witch134517562witch
zilches21326302zilches
zill135727612zil_l
zillah1836562zillah
zills144020782zills
zinc156819092zinc_
zincs165312932zincs
zincy195413512zincy
ail37171043ail__
ailed66240283ailed
ails45654713ail_s
airth85621023airth
arch98628443_arch
bach116131393_bach
batch124620103batch
beach124623893beach
beech124315503beech
bench125619503bench
bice86235563bi_ce
bilbo95513613bilbo
bilby124912353bilby
bile66147183bil_e
biles75542143biles
bilge87618913bilge
bilgy114713713bilgy
bilk105824423bil_k
bilks115117893bilks
bill67239943bil_l
bills75632863bills
billy105525363billy
bimah127013263bimah
birth105619873birth
bitchy16479203bitchy
blah98625063_blah
botch126717453botch
brach126123303brach
bunch125118603bunch
butch125416543butch
catch125120373catch
chinch163911223chinch
cilia73016763cilia
cilice103213353cilice
circa9311403circa
cisco95112133cisco
clach124617823clach
cliche133712453cliche
click135217953click
clinch133910353clinch
coach125919453coach
conch124620073conch
cooch124916833cooch
couch125320113couch
cultch13385953cultch
curch124415413curch
cutch125116193cutch
dice75841893di_ce
dick116432383di_ck
dildo71911773dildo
dill55239973dil_l
dills65530973dills
dilly94923783dilly
disc76123233disc_
disci85815023disci
disco85616073disco
discs85316263discs
dish86328333di_sh
dolce85816683dolce
dolci84912603dolci
dunch115316263dunch
dutch114713823dutch
each95530583_each
epoch1248203epoch
etch95419143_etch
fetch134913473fetch
fice95737113fi_ce
fiche134616743fi_che
fichu134810663fi_chu
fico95824593fi_co
fifth145210923fifth
fil65447143fil__
fila74729133fil_a
filar84819293filar
filched16307423filched
filcher15377793filcher
filches153410723filches
file75446643fil_e
filed95331903filed
filer85433003filer
files85441273files
filet85540163filet
fill75540193fil_l
fille84327403fille
fillo84319783fillo
fills84632373fills
filly114424903filly
film94828173fil_m
filmi105914003filmi
films105617963films
filmy136114043filmy
filo76034283fil_o
filos86125383filos
fils75838693fil_s
filths12389783filths
filthy15356423filthy
filum105015433filum
finca104714503finca
firth115819533firth
fisc96819753fisc_
fiscs105311883fiscs
fish106926273fi_sh
fitchy17437623fitchy
flic96223733flic_
flick145017213flick
flics105418363flics
flinch144010103flinch
flitch14928173flitch
galah95917623galah
gild65526513gil_d
gilds75417523gilds
gill56336183gil_l
gills64728193gills
gilly94321633gilly
gilt56348543gil_t
gilts64924263gilts
girsh95310023girsh
girth95618843girth
glitch12286353glitch
grinch1238473grinch
hatch135719593hatch
heuch135312333heuch
hic86540563hi_c_
hick135530303hi_ck
high116619913hi_gh
hila76228353hil_a
hilar85418143hilar
hili75626633hil_i
hill76439493hil_l
hillo84721653hillo
hills85431353hills
hilly114422163hilly
hilt75850713hil_t
hilts86924413hilts
hilum105514603hilum
hilus84817643hilus
hooch135813703hooch
hotch136214723hotch
hunch136416213hunch
hutch135414093hutch
ice56737243_i_ce
ichs96214713_i_chs
ick97329323_i_ck
icy86322123_i_cy
ilea45931463_ilea
ilex115822033_ilex
ilia46026823_ilia
ilk78325303_il_k
ilka87215153_ilka
ilks87218573_ilks
ill37437093_il_l
ills47030423_ills
illy76925333_illy
itchy13449013_itchy
jill116430263jil_l
jills125122823jills
jilt115839423jil_t
jilts124717413jilts
kench145513923kench
ketch144912023ketch
kiblah1535583kiblah
kick96026063ki_ck
kilim11711883kilim
kill85533173kil_l
kills94526173kills
kiln85620973kil_n
kilns95112983kilns
kilo86028663kil_o
kilos95021473kilos
kilt86144413kil_t
kilts95122183kilts
kilty125213893kilty
kimchi1743803kimchi
kirsch1532713kirsch
kith115826353ki_th
kitsch1533353kitsch
klick105311433klick
laich105920713laich
larch105919793larch
latch104620463latch
leach105422523leach
lech96825443_lech
leech104913213leech
letch105215803letch
lice66045063li_ce
lichi104412953li_chi
licht104723493li_cht
lick106935073li_ck
lilac7311073lilac
lilacs837483lilacs
lilo46731563lil_o
lilos55821873lilos
lilt46349943lil_t
lilts55822803lilts
lily76730183lil_y
litchi1137893litchi
loach105116363loach
loch95527133_loch
lunch104917243lunch
lurch104814633lurch
lych126015763_lych
lynch13468983lynch
mach116134473_mach
march125622893march
match125621103match
merch125417963merch
mic77647643mi_c_
mica86428253mi_ca
mice87442233mi_ce
miche126219243mi_che
mick126333433mi_ck
mics87435153mi_cs
mil55752113mil__
milchig1543653milchig
mild75330853mil_d
milds86422053milds
mile66352573mil_e
miler75733063miler
miles74645073miles
milia72719573milia
milk105028473mil_k
milks115020583milks
milky144014443milky
mill66541483mil_l
mille75029133mille
mills75435053mills
milo65536103mil_o
milos75428013milos
milpa92111403milpa
mils66045333mil_s
milt65455813mil_t
milts75430713milts
milty104720073milty
mince95325233mince
mincy125817413mincy
mirth106418893mirth
moloch1356483moloch
mooch125313613mooch
mouch124715803mouch
much115224033_much
mulct93820083mulct
munch124917103munch
mutch125016173mutch
natch105018223natch
nice65534713ni_ce
niche105016793ni_che
nick106627603ni_ck
niece74814503niece
nigh85220663ni_gh
nil36144193nil__
nill45634303nil_l
nills54926673nills
nils46132453nil_s
ninth8314583ninth
notch105613323notch
oil37452053oil__
oilcan837793oilcan
oilcup1044253oilcup
oiled64429473oiled
oiler54628283oiler
oils46337973oil_s
oily77932253oil_y
orach105219233orach
ouch95724633_ouch
painch133511323painch
parch125123003parch
patch125221223patch
peach125422493peach
pech116125453_pech
perch124518833perch
pic76046823pi_c_
pica85831493pi_ca
pice84641093pi_ce
pick125933813pi_ck
pics85633913pi_cs
piece96717993piece
pilaf103923483pilaf
pilar75221503pilar
pilau73618523pilau
pilaw103913743pilaw
pile65649693pil_e
pilea75123953pilea
piled85232993piled
pilei74021783pilei
piles74742613piles
pili66130353pil_i
pilis75825203pilis
pill65339463pil_l
pills74130973pills
pilot77435063pilot
pilus75921063pilus
pily96132733pil_y
pisco96314983pisco
pish96127913pi_sh
pitchy16479673pitchy
pith95432693pi_th
plica9613373plica
poach124917863poach
pooch124815303pooch
porch125918623porch
pouch124617083pouch
psych1554963psych
punch125118423punch
quitch2036413quitch
ralph1078743ralph
ranch105019793ranch
ratch104221363ratch
reach105123883reach
retch104818303retch
rice64942913ri_ce
rick107334653ri_ck
rile45650533ril_e
riled65833253riled
riles55343643riles
riley84420583riley
rill45140903ril_l
rille55728733rille
rills55032713rills
roach105717003roach
rotch105815933rotch
sauch104918773sauch
sculch13226213sculch
selah8319613selah
sic55847873si_c_
sice65545593si_ce
sick106435573si_ck
sics65234093si_cs
sidh86222983si_dh
sigh85625893si_gh
sild55030583sil_d
silds65520523silds
silex123417413silex
silica8311243silica
silk85529323sil_k
silks94620683silks
silky125315823silky
sill45545153sil_l
sills55135983sills
silly84527613silly
silo46037913sil_o
silos56029423silos
silt46558193sil_t
silts55330823silts
silty84721633silty
silva82714023silva
since75024173since
sinh76238043si_nh
sith75435153si_th
sixth155512233sixth
slice74925823slice
slick115520523slick
smirch1356463smirch
snitch11357943snitch
spilth11469733spilth
stich104117923stich
stitch11419103stitch
such96424813_such
sulci7615053sulci
switch14458913switch
sylph1347793sylph
synch135011793synch
tach96132753_tach
talc66226813talc_
talcs74817183talcs
teach105221123teach
tech95925443_tech
telco7511873telco
tench105620003tench
teuch105214853teuch
tic56343463ti_c_
tick106231223ti_ck
tics65729633ti_cs
til36350263til__
tilak91011553tilak
tilde65017343tilde
tile45451443til_e
tiled64832943tiled
tiler56131023tiler
tiles55542103tiles
till45941203til_l
tills54631703tills
tils45739613til_s
tilt46252423til_t
tilths9459373tilths
tilts55325613tilts
tinct76126233tinct
torch107420933torch
touch106519393touch
twitch14406163twitch
vetch134411843vetch
vice95732853vi_ce
vichy1639043vi_chy
vile76139803vil_e
viler86324163viler
vill75235073vil_l
villa85321233villa
villi86517853villi
vills86429323vills
vinca105315163vinca
vouch134611903vouch
watch135617063watch
welsh113110363welsh
wench136214783wench
which163910083which
wicca1247253wicca
wick135726303wi_ck
width12310963width
wild85126513wil_d
wilds94818203wilds
wile75944373wil_e
wiled95231553wiled
wiles85437873wiles
will75737513wil_l
wills84528963wills
willy115321913willy
wilt76246293wil_t
wilts85023503wilts
wily106428813wil_y
wince105220883wince
wish107228733wi_sh
witchy17468593witchy
with105730473wi_th
wych154011883_wych
yecch15558093yecch
yech127220533_yech
yill75628973yil_l
yills83921553yills
yince105214253yince
yirth116513753yirth
yucch15417433yucch
yuch125818533_yuch
zibet16419733zibet
zibeth2034173zibeth
zig136931903zi__g
zigs145422793zi_gs
zillahs1935383zillahs
zin125643773zi__n
zinced18419413zinced
zincic1935903zincic
zincky24404963zincky
zine137036153zi_ne
zineb165614143zineb
zines145232653zines
zing145728613zi_ng
zings154620893zings
zingy186516133zingy
zinky215314813zinky
zins135735003zi_ns
zip146636223zi__p
ziplock2454413ziplock
zippy21518743zippy
zips155723793zi_ps
ziram163912893ziram
zircon1754953zircon
zit126049993zi__t
ziti136022373zi_ti
zitis145815583zitis
zits136030293zi_ts
zizit13313273zizit
zizith1744823zizith
zoic152316073zoic_

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.1231452772.4
2DLD Change Limit836674973.75322293.4
3Display Results4974970.1234040.7
 (SQL Overall)1786914973.99944683.9
 
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.