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

405 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
ditched14371190(None) 
bitched153212921bitched
ditcher134012001ditcher
ditches133215711ditches
hitched163312251hitched
itched123812021_itched
pitched153512921pitched
witched163012191witched
aitches123014362aitches
batched154114242batched
birched15349912birched
bitchen14349732bitchen
bitches144117062bitches
botched153611902botched
cinched153910862cinched
detached1537732detached
diced95824682di_c_ed
dicked144920862di_cked
disced104914652disc_ed
discoed11312482discoed
dished114318712di_shed
ditch115015092ditch__
ditchers143610362ditchers
dither104417682dit_her
dittoed936732dittoed
douched144012112douched
etched123613702_etched
fetched163710472fetched
filched16307422filched
fitchee152710782fitchee
fitches153516192fitches
fitchet153113562fitchet
fitchew18276802fitchew
flitched17256292flitched
hatched163414462hatched
hitcher153712002hitcher
hitches153616272hitches
hotched163610922hotched
hutched16359882hutched
inched124514482_inched
itches114916212_itches
kitchen16287682kitchen
kithed144613012kit_hed
latched133914062latched
letched133912052letched
matched153513962matched
miched143913392mi_ched
niched125514062ni_ched
notched134210302notched
patched153514622patched
pinched153812452pinched
pitcher143813712pitcher
pitches143617752pitches
pithed124615612pit_hed
retched133814272retched
snitched14166862snitched
stitched14148202stitched
switched17157132switched
tetched133010772tetched
tithed104115592tit_hed
twitched17155032twitched
watched163012822watched
winched163110592winched
witches152715792witches
withed134416232wit_hed
ached119227833__ached
airshed11258533airshed
airthed11328303airthed
aitch105216163aitch__
arched125717323_arched
attached14165703attached
bached145519893_bached
batcher144414853batcher
batches144019613batches
bathed125518743bat_hed
beached154516553beached
belched154011843belched
benched154713943benched
bewitched2043233bewitched
birchen14347883birchen
birches143412323birches
birthed13228593birthed
bitch125017763bitch__
bitchery18236563bitchery
bitchier15307733bitchier
bitchy16479203bitch_y
bitted94418483bit_ted
blotched1635653blotched
botcher143613223botcher
botches143716023botches
britches15278683britches
bunched154312413bunched
butcher143411163butcher
butches144315363butches
cached145419203_cached
catcher143115823catcher
catches144320773catches
cinches144215773cinches
circled1237583circled
cited84421953cit__ed
cither114616683cit_her
citied94014143cit_ied
cliched153711023cliched
clinched16347383clinched
clutched16356033clutched
coached153313843coached
couched154115793couched
crotched16428593crotched
crutched16307463crutched
cutches143216463cutches
danced105315253danc_ed
dashed115920563d_ashed
datcha1266563datch_a
datchas1347423datchas
dated75530993dat__ed
deashed123411303deashed
decked145217623d_ecked
deiced104214483deic_ed
detacher1437543detacher
detaches1439653detaches
detected12289733detected
deticked1635693deticked
detoxed1636103detoxed
deuced104112123deuc_ed
diacid10310633diac_id
dialed84716453di_aled
dialled9510133dialled
dibbed124713473di_bbed
dibbled133510843dibbled
dice75841893di_c_e_
dicer85426423di_c_er
dices86434243di_c_es
dicey114819333di_c_ey
dicier94416233di_cier
dicker134521403di_cker
dickey165913523di_ckey
dickhead1944143dickhead
dictated1239203dictated
dictier103411863dictier
diddled114212053diddled
died66137853di___ed
dieted83115493di_eted
diether1147443diether
digged104314653di_gged
dighted132511493dighted
diked115024683di__ked
dilated93115823dilated
dilled84122223di_lled
diluted9248933diluted
dimmed124110323di_mmed
dimpled132810303dimpled
dindled104412723dindled
dined76431993di__ned
dinged95221783di_nged
dinked124818353di_nked
dinned84317613di_nned
dinted84419843di_nted
dipped123517493di_pped
directed1238233directed
dirked124912273di_rked
dirled84514903di_rled
dirtied93210853dirtied
discard11310213discard
discased122510853discased
discoid11311243discoid
discord1139993discord
dishes104622653di_shes
disked125015763di_sked
dispatched1993883dispatched
dissed85220183di_ssed
disused93211033disused
ditching15349943ditching
dite55547553dit__e_
dites66339153dit__es
dithered13189293dithered
dithers114016153dit_hers
dithery14318943dit_hery
ditsier83010293ditsier
ditties83116983ditties
ditzes163212423dit_zes
ditzier17307963ditzier
dived106321373di__ved
divided13378593divided
divined12329693divined
divvied1544813divvied
dizened18267333dizened
dizzied17236133dizzied
docked145018333d_ocked
doited85016633doit__ed
doted75227073dot__ed
dotted84717523dot_ted
douche124613223douche_
douches134315233douches
dowitcher1842593dowitcher
drenched15247913drenched
ducked144718013d_ucked
ducted104012123d_ucted
dunches133312583dunches
dutch114713823dutch__
dutchmen1643163dutchmen
eched116919223__eched
edited83913673edit__ed
either94517423eit_her
etcher113912943_etcher
etches114217763_etches
faithed1437163fait_hed
fetcher153510393fetcher
fetches153413893fetches
fiche134616743fi_che_
fiches145219533fi_ches
filcher15377793filcher
filches153410723filches
finches153914193finches
fished134316313fi_shed
fitch134816873fitch__
fitchets16307413fitchets
fitchews19274773fitchews
fitchy17437623fitch_y
fitted104716663fit_ted
fletched17306693fletched
flinched17316703flinched
flitches16388463flitches
girthed12266243girthed
gitted84015053git_ted
glitches14296653glitches
grutched15284673grutched
hatchel153510753hatchel
hatcher153314723hatcher
hatches153420273hatches
hatchet153317563hatchet
hitch134515473hitch__
hitchers16379993hitchers
hither124417253hit_her
hotches153814363hotches
hunched163710493hunched
hutches153613523hutches
iced78721893_i_c_ed
incher114114033_incher
inches114419673_inches
itch95619173_itch__
itchier12247673_itchier
itchy13449013_itch_y
itemed936603_itemed
ither84617603_it_her
ketches164012193ketches
kicked124415943ki_cked
kimchee1845603kimchee
kitchens17195783kitchens
kited105120093kit__ed
kithe125917453kit_he_
kithes135016653kit_hes
kitsches1734073kitsches
kitted115114833kit_ted
kittled12388193kittled
kvetched2142783kvetched
kythed17407313kyt_hed
latches123320123latches
latchet123117903latchet
lathed104718453lat_hed
leached133715043leached
leched123716003_leched
leeched13369503leeched
letches124015483letches
lichee114017973li_chee
lichen114012743li_chen
liches114724293li_ches
lichted13268803li_chted
licked134621563li_cked
litchi1137893litch_i
litchis1238373litchis
lithe84922013lit_he_
lither94520953lit_her
lithoed1137833lithoed
lunched133911823lunched
lurched13358033lurched
lynched16376753lynched
marched153813403marched
matcher143214283matcher
matches143219783matches
miche126219243mi_che_
miches134320733mi_ches
minced114114913minc_ed
miscued1239293miscued
mitered103213233mitered
mither114218563mit_her
mitred94414343mit_red
mooched153910533mooched
mouched153612593mouched
mulched15307763mulched
munched153411073munched
mutches143314283mutches
niche105016793ni_che_
niches114419143ni_ches
nicked135019683ni_cked
nighed113811293ni_ghed
nitchie1247233nitchie
nitchies1339073nitchies
notcher123610933notcher
notches123513653notches
ouched124316933_ouched
outchid1338723outchid
parched154013693parched
patcher143515143patcher
patches143320383patches
peached154315883peached
peched144915343_peched
perched154713243perched
picked154421313pi_cked
pieced113912103piec_ed
pincher143812713pincher
pinches144117933pinches
pished124817063pi_shed
pitch125018413pitch__
pitchers153211483pitchers
pitchier15368273pitchier
pitchmen1744333pitchmen
pitchy16479673pitch_y
pithead13419593pit_head
pitied94017253pit_ied
pitted94319593pit_ted
poached154212403poached
pooched152810083pooched
pouched153612773pouched
psyched1843913psyched
punched153512173punched
quitches2236193quitches
ranched133113603ranched
ratches123620463ratches
ratchet124218333ratchet
reached134619083reached
retches123318513retches
riced85825543ri_c_ed
richen113812513ri_chen
richer114015043ri_cher
riches115022083ri_ches
ricked136523623ri_cked
roached133211833roached
rotche114311983rotche_
rotches123515703rotches
ruched124314633_ruched
satchel123310303satchel
scotched16187933scotched
scutched16186893scutched
sicced11489653si_cced
sicked134524403si_cked
sighed113712053si_ghed
sited65130743sit__ed
sketched1835393sketched
smirched1634673smirched
smutched16165923smutched
snatched14157633snatched
snitcher13157373snitcher
snitches13148983snitches
sticked144114633sticked
stitcher13168393stitcher
stitches131410593stitches
switcher16177683switcher
switches16159133switches
synched16277213synched
teched124014433_teched
thatched1735433thatched
ticced11438443ti_cced
ticked134720523ti_cked
tincted1037273tincted
tithe85319703tit_he_
tither94920283tit_her
tithes94720213tit_hes
titled73815003tit_led
torched133511353torched
touched134914963touched
twitcher16135343twitcher
twitches16156373twitches
tythed13457503tyt_hed
unhitched1843093unhitched
vetches153411263vetches
viced115118183vi_c_ed
vittled11347343vittled
vouched163910563vouched
watcher153113403watcher
watches153017373watches
welched16298833welched
wenched163910913wenched
wiches144418753wi_ches
wicked164317413wi_cked
winced124415343winc_ed
wincher153410653wincher
winches154714373winches
wished134417513wi_shed
witch134517563witch__
witchery19236093witchery
witchier16307883witchier
witchweed2142773witchweed
witchy17468593witch_y
wited94727143wit__ed
withe115220233wit_he_
wither124321353wit_her
withes124620843wit_hes
withheld1842353withheld
witted104216813wit_ted
wretched17276533wretched
writhed14389623writ_hed
zilches21326303zilches
zinced18419413zinc_ed
zincked2334233zincked
zither183813083zit_her

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 Filter1786911340270.623286823.4
2DLD Change Limit1340274055.90622693.4
3Display Results4054050.1402892.9
 (SQL Overall)1786914056.66926794.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.