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

354 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
cratches15301254(None) 
catches144320771c_atches
cranches153114541cranches
crotches153411301crotches
crutches15359591crutches
ratches123620461_ratches
scratches1647321scratches
batches144019612_batches
braches144621222bra_ches
branches153613802branches
britches15278682britches
caches137926912c_a_ches
caroches15710692caroches
catcher143115822c_atcher
catchers153114062c_atchers
chatchkes23174742chatchkes
clutches15307922clutches
coaches144018692coa_ches
cranched163210412cranched
crashes124618402cra_shes
cratch134110792cratch__
crates85736062crat__es
craunches1655722craunches
creches14313092cr_eches
crotched16428592crotched
crotchet152711992crotchet
crotchets16396302crotchets
crouches153711292crouches
crunches153711352crunches
crutched16307462crutched
cultches15316532cultches
cutches143216462c_utches
grutches14285852grutches
hatches153420272_hatches
klatches17157142klatches
latches123320132_latches
matches143219782_matches
oraches124216472ora_ches
patches143320382_patches
ranches123620112_ranches
ratchet124218332_ratchet
ratchets133110262_ratchets
retches123318512_retches
rotches123515702_rotches
scratched1735392scratched
scratcher1635442scratcher
scratchers1744292scratchers
slatches131511532slatches
snatches131410712snatches
swatches16169962swatches
thatches1637512thatches
tranches132915512tranches
watches153017372_watches
wretches16257282wretches
aches106132293__a_ches
aitches123014363_aitches
apaches143411843apa_ches
arches114822043__arches
attaches13137723attaches
baches135426943_ba_ches
batched154114243_batched
batcher144414853_batcher
batchers153613273_batchers
bathes116524833_bat_hes
beaches144120653bea_ches
bitches144117063_bitches
blanches153311603blanches
blotches1537433blotches
botches143716023_botches
braces108427773bra_c_es
brachet144020313bra_chet
brachets154311983bra_chets
brachs134415753bra_ch_s
branched163210453branched
brashes124518463bra_shes
brattles10199333brattles
breaches153714123breaches
breathes134212903breat_hes
breeches15258673breeches
brioches15227253brioches
broaches153211623broaches
brooches15288193brooches
brunches153710453brunches
butches144315363_butches
bycatches2142683bycatches
cache125122483c_a_che_
cached145419203c_a_ched
cachet134526413c_a_chet
cachets145014263c_a_chets
calces104420053c_alc_es
caleches15269943caleches
caliches153812273caliches
canchas143212403c_anchas
capuches1735513capuches
carates95630613carat__es
carices114220953caric_es
caroaches1637793caroaches
caroche1469243caroche_
carritches1743083carritches
carroches1665893carroches
cartages11313313cartages
cartes86239473cart__es
cartouches17112963cartouches
cashes114729883c_a_shes
catch125120373c_atch__
catchier15329863c_atchier
catchiest1638313c_atchiest
catchup1644793c_atchup
catchups1744383c_atchups
catchy16559583c_atch_y
catechus1544823c_atechus
cates75951893c_at__es
catties94023053c_atties
cerates95428253cerat__es
ceviches1834843ceviches
chances145218093chanc_es
chancres15429363chancres
chatchka22202893chatchka
chatchkas23172783chatchkas
chatchke22153883chatchke
chinches18369363chinches
churches1846433churches
cinches144215773c_inches
clachs133511323cla_ch_s
clashes124017283cla_shes
clenches152910953clenches
cliches144213743c_liches
clinches153910363clinches
cloches144113713c_loches
clothes124513813clot_hes
clutched16356033clutched
coached153313843coa_ched
coacher143714123coa_cher
coachers154312303coa_chers
coatees93816553coat_ees
conches144019813c_onches
cooches143515833c_ooches
coracles121811163cora_cles
corniches1666673corniches
couches144020473c_ouches
cracked163514743cra_cked
cracker153114173cra_cker
crackers164111723cra_ckers
crackles164111273crackles
cracks144817003cra_c_ks
cradles103114133cra_dles
crakes124921813cra__kes
crambes1339963cra_mbes
cramboes1436543cramboes
cranch133613533cranch__
cranes84330753cra__nes
crankles143510153crankles
crannies10313013crannies
crapes104727693cra__pes
crappies142911163crappies
crases85532313cra__ses
crashed134214203cra_shed
crasher124616163cra_sher
crashers134013233cra_shers
crate76537403crat__e_
crated94827773crat__ed
crater85026643crat__er
cratered1149683cratered
craters95021893crat_ers
cratons94316033crat_ons
craunched1764023craunched
craves115825393cra__ves
crazes174720133cra__zes
crazies183413853cra_zies
creates95225203creat__es
creatines112814433creatines
creatives14279693creatives
creatures1138423creatures
creche13310763cr_eche_
creeshes1336953creeshes
crochet143616663cr_ochet
crochets15359833cr_ochets
crotch133410083crotch__
crotchety19403813crotchety
crouched16359143crouched
cruces105117543cr_uc_es
crunched16328163crunched
cruncher15338073cruncher
crunchers16316243crunchers
crushes124215133cr_ushes
crutch13408243crutch__
crwths1433433crwt_h_s
culches143710743c_ulches
curacies12311763cura_cies
curates95323833curat__es
curatives1437823curatives
curches143512743c_urches
datchas1347423_datchas
detaches1439653detaches
ditches133215713_ditches
drachms1534253dra_chms
drenches14309803drenches
earaches13411313earaches
etches114217763__etches
fetches153413893_fetches
fitches153516193_fitches
fletches16308853fletches
flitches16388463flitches
frenches163311633frenches
glitches14296663glitches
graces94523493gra_c_es
grates75429893grat__es
grinches1436953grinches
grouches14328213grouches
grutched15284673grutched
hatched163414463_hatched
hatchel153510753_hatchel
hatchels16368673_hatchels
hatcher153314723_hatcher
hatchers163113173_hatchers
hatchet153317563_hatchet
hatchets163310383_hatchets
hitches153616273_hitches
hootches1656973hootches
hotches153814363_hotches
hutches153613523_hutches
inarches1358043inarches
itches114916213__itches
ketches164012193_ketches
klatsches1842233klatsches
kvetches2053583kvetches
laches116528353_la_ches
larches124416453_larches
latched133914073_latched
latchet123117913_latchet
latchets133410013_latchets
lathes95127503_lat_hes
leaches123319343lea_ches
letches124015483_letches
loaches123613983loa_ches
loathes103513243loat_hes
maches134827233_ma_ches
manches143818623_manches
marches143921173_marches
matched153513963_matched
matcher143214283_matcher
matchers153012433_matchers
mutches143314283_mutches
naches114622413_na_ches
nautches1336083nautches
notches123513653_notches
orache114013593ora_che_
oracles93212423ora_cles
orates64328613orat__es
parches143720003_parches
patched153514623_patched
patcher143515143_patcher
patchers153413303_patchers
peaches144120053pea_ches
pitches143617753_pitches
planches153111863planches
poaches144416943poa_ches
prances113618773pranc_es
prates84633163prat__es
prattles10189403prattles
preaches153214893preaches
quaiches2235343quaiches
quitches2236193quitches
races74943243_ra_c_es
rachet115028973_ra_chet
rachets124516833_ra_chets
rachis114017653_ra_chis
rances84625443_ranc_es
ranched133113603_ranched
rancher123013633_rancher
ranchers133311793_ranchers
ranchos123911393_ranchos
raphes115117453_ra_phes
rashes95330153_ra_shes
ratch104221363_ratch__
rates55352013_rat__es
rathe85821923_rat_he_
rather94319743_rat_her
ratines75328583_ratines
ratites74920683_ratites
rattles73217303_rattles
raunches1368053_raunches
reaches123423203_reaches
rematches1636653rematches
repatches1636713repatches
retched133814273_retched
riches115022083_r_iches
roaches123616213_roaches
rotche114311983_rotche_
rouches124217893_rouches
ruches114819583_r_uches
satchel123310303_satchel
satchels13328163_satchels
scathes124515713scat_hes
schatchen1943853schatchen
schatchens2042683schatchens
scootches1635003scootches
scotches15179473scotches
scraiched1744203scraiched
scraichs1543993scraich_s
scratch1446013scratch__
scratchier1744343scratchier
scratchiest1844143scratchiest
scratchy1843653scratch_y
screeches1695653screeches
scrooches1645703scrooches
scrootches1743323scrootches
scrunches1635403scrunches
scultches1664293scultches
scutches15168883scutches
searches132112903searches
sketches1746823sketches
smutches15177273smutches
snatched14157633snatched
snatcher13167763snatcher
snatchers14146313snatchers
snathes104816493snat_hes
snitches13148983snitches
spathes125116533spat_hes
stanches132312793stanches
starches131912913starches
stitches131410593stitches
stretches1438293stretches
swathes134115513swat_hes
switches16159133switches
taches114224173_ta_ches
teaches122718353tea_ches
thatched1735433thatched
thatcher1635663thatcher
thatchers1744583thatchers
traces85329933tra_c_es
trachea12311683tra_chea
tracheas13410273tra_cheas
trachles13311753tra_chles
trances93919643tranc_es
tranche123312223tranche_
trashes104119263tra_shes
trauchles1445493trauchles
trenches133512603trenches
troches123715343tr_oches
twitches16156373twitches
unlatches1444303unlatches
urates65027763urat__es
vetches153411263_vetches
watched163012823_watched
watcher153113403_watcher
watchers163511793_watchers
witches152715793_witches
wrathed14298523wrat_hed
wraths123810083wrat_h_s
wreathes14299893wreat_hes
wrenches163210233wrenches
wretched17276533wretched
writhes134811703writ_hes

Search took 8 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 Filter1786911461620.453394461.4
2DLD Change Limit1461623547.22020244.0
3Display Results3543540.1402528.6
 (SQL Overall)1786913547.81322871.0
 
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.