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

407 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
cranches15311454(None) 
branches153613801branches
cranched163210411cranched
cratches153012541cratches
craunches1655721craunches
crunches153711351crunches
ranches123620111_ranches
tranches132915511tranches
blanches153311602blanches
braches144621222bra_ches
branched163210452branched
brunches153710452brunches
caches137926912c_a_ches
canchas143212402c_anchas
caroches15710692caroches
catches144320772c_atches
chances145218092chanc_es
chancres15429362chancres
chinches18369362chinches
cinches144215772c_inches
clenches152910952clenches
clinches153910362clinches
coaches144018692coa_ches
conches144019812c_onches
cranch133613532cranch__
cranes84330752cran__es
crankles143510152crankles
crannies10313012crannies
crashes124618402cra_shes
craunched1764022craunched
creches14313092cr_eches
crotches153411302crotches
crouches153711292crouches
crunched16328162crunched
cruncher15338072cruncher
crunchers16316242crunchers
crutches15359592crutches
drenches14309802drenches
frenches163311632frenches
grinches1436942grinches
manches143818622_manches
oraches124216472ora_ches
planches153111862planches
prances113618772pranc_es
rances84625442_ranc_es
ranched133113602_ranched
rancher123013632_rancher
ranchers133311792_ranchers
ranchos123911392_ranchos
ratches123620462_ratches
raunches1368052_raunches
scratches1647322scratches
scrunches1635402scrunches
stanches132312792stanches
trances93919642tranc_es
tranche123312222tranche_
trenches133512602trenches
wrenches163210232wrenches
aches106132293__a_ches
anchos114214893__anchos
apaches143411833apa_ches
arches114822043__arches
baches135426943_ba_ches
batches144019613_batches
beaches144120653bea_ches
benches143918603_benches
blanched16308603blanched
blancher15338633blancher
blanchers16307433blanchers
blenches153310763blenches
braces108427773bra_c_es
brachet144020313bra_chet
brachets154311983bra_chets
brachs134415753bra_ch_s
branch134014773branch__
branchia15217713branchia
branchier1637133branchier
branchiest1746713branchiest
branchless1743303branchless
branchlet1647183branchlet
branchlets1743803branchlets
branchy17357913branch_y
brandies11714563brandies
brashes124518463bra_shes
breaches153714123breaches
breeches15258673breeches
brioches15227253brioches
britches15278683britches
broaches153211623broaches
bronchos15206173bronchos
bronchus15204743bronchus
brooches15288193brooches
brunched16317853brunched
bruncher15347783bruncher
brunchers16296253brunchers
bunches144116033_bunches
cache125122483c_a_che_
cached145419203c_a_ched
cachet134526413c_a_chet
cachets145014263c_a_chets
calces104420053c_alc_es
caleches15269933caleches
caliches153812263caliches
canapes111213083c_anapes
cancans11311873c_ancans
cancel105316683c_anc_el
cancels114113313c_ancels
cancer104220923c_anc_er
cancers114018583c_ancers
cancha134411613c_anch_a
candies104125613c_andies
candles104422343c_andles
canes75350373c_an__es
cangues10611823c_angues
canines93724033c_anines
canoes84725883c_an_oes
canthus1248713c_anthus
cantles94721413c_antles
capuches1735513capuches
carices114220953caric_es
carnages11312213carnages
carnies94123963carn_ies
caroaches1637793caroaches
caroche1469243caroche_
carroches1665893carroches
caruncles1345003caruncles
cashes114729883c_a_shes
catcher143115823c_atcher
catchers153114063c_atchers
cenacles1238023cenacles
ceviches1834843ceviches
chance134617093chanc_e_
chanced154113213chanc_ed
chancel144011773chanc_el
chancels15439083chancels
chancer144215633chanc_er
chancers154313493chancers
chancier1538823chancier
chanciest1638373chanciest
chancre14348783chancre_
changes134517583chan_ges
chanties132615803chanties
chatchkes23174743chatchkes
churches1846433churches
cinched153910863c_inched
clachs133511323cla_ch_s
clashes124017283cla_shes
clenched16257763clenched
clencher15277973clencher
clenchers16276553clenchers
cliches144213743c_liches
clinched16347383clinched
clincher15347663clincher
clinchers16336263clinchers
cloches144113713c_loches
clutches15307923clutches
coached153313843coa_ched
coacher143714123coa_cher
coachers154312303coa_chers
coanchor1545253coanchor
coanchors1645733coanchors
conchas144013313c_onchas
conchies153214853c_onchies
conchos144313963c_onchos
conchs134714903c_onch_s
cooches143515833c_ooches
coracles121811163cora_cles
corantoes1147653corantoes
corniches1666673corniches
couches144020473c_ouches
cracked163514743cra_cked
cracker153114173cra_cker
crackers164111723cra_ckers
crackles164111273crackles
cracks144817003cra_c_ks
cradles103114133cra_dles
crakes124921813cra__kes
crambes1339963cra_mbes
cramboes1436543cramboes
cranching17278733cranching
crane75331603cran__e_
craned96121653cran__ed
craniates11310653craniates
craniums1297913craniums
crankcase1742343crankcase
crankcases1842763crankcases
cranked143812843cran_ked
cranker133612783cran_ker
crankest1438143cran_kest
crankier14339163crankier
crankiest1538823crankiest
crankle133610063crankle_
crankled15408153crankled
crankous1435973crankous
cranks125015313cran__ks
crannied1137893crannied
crannoges1244243crannoges
crannogs1143783crannogs
crapes104727693cra__pes
crappies142911153crappies
crases85532313cra__ses
crashed134214203cra_shed
crasher124616163cra_sher
crashers134013233cra_shers
cratch134110793cratch__
crates85736063cra__tes
craunch1464443craunch__
craves115825393cra__ves
crazes174720133cra__zes
crazies183413853cra_zies
creche13310763cr_eche_
creeshes1336953creeshes
cringes103215503crin_ges
cringles11329463cringles
crinites10612763crinites
crinkles14269163crinkles
crochet143616663cr_ochet
crochets15359833cr_ochets
crones84729243cron__es
cronies9622503cron_ies
crotched16428593crotched
crotchet152711993crotchet
crotchets16396303crotchets
crouched16359143crouched
cruces105117543cr_uc_es
crunch13349503crunch__
crunchier1644683crunchier
crunchiest1764793crunchiest
crunchy17324763crunch_y
crunodes1144973crunodes
crushes124215133cr_ushes
crutched16307463crutched
culches143710743c_ulches
cultches15316533cultches
curacies12311763cura_cies
curches143512743c_urches
cutches143216463c_utches
cyanates13238433cyanates
cyanides14258003cyanides
cyanines132710543cyanines
cyanites132610163cyanites
cyanoses1337423cyanoses
dances95120653_danc_es
drachms1534253dra_chms
drenched15247913drenched
drencher14257213drencher
drenchers15296103drenchers
dunches133312583_dunches
durances1158683duranc_es
earaches13411303earaches
errancies1147963errancies
fancies124018783_fancies
fiancees1335103fiancees
fiances12310673fianc_es
finches153914193_finches
flenches163410533flenches
flinches16358953flinches
franchise1746003franchise
franchises1855633franchises
francizes2346793francizes
francs114112193franc__s
frenched17299433frenched
ganaches1437413_ganaches
glances104113143glanc_es
glunches1436263glunches
graces94523493gra_c_es
grandees103211283grandees
granges93516523gran_ges
granites92116363granites
grannies9312613grannies
grantees92510973grantees
granules939933granules
grouches14328213grouches
grutches14285853grutches
hances115621283_hanc_es
hatches153420273_hatches
haunches1656963haunches
hunches153913463_hunches
inarches1358043inarches
inches114419673__inches
kenches163912273_kenches
klatches17157133klatches
laches116528343_la_ches
lances84824103_lanc_es
larches124416443_larches
latches123320123_latches
launches1387903launches
leaches123319343lea_ches
loaches123613983loa_ches
lunches124115443_lunches
lynches15378873_lynches
maches134827233_ma_ches
manche133515103_manche_
manchet143317773_manchet
manchets15269573_manchets
marches143921173_marches
matches143219783_matches
munches144215793_munches
naches114622413_na_ches
nances83618643_nanc_es
nancies93516843_nancies
nuances938523nuanc_es
orache114013593ora_che_
oracles93212423ora_cles
oranges84215333oran_ges
painches1588913painches
panaches15310283_panaches
panoches1548123_panoches
parches143720003_parches
patches143320383_patches
paunches1568173paunches
peaches144120053pea_ches
pinches144117933_pinches
planche14299753planche_
planchet152511963planchet
planchets16236743planchets
plenches153110623plenches
poaches144416943poa_ches
prance104318573pranc_e_
pranced123714043pranc_ed
prancer113613383pranc_er
prancers123210333prancers
preaches153214893preaches
princes113015143princ_es
punches144816133_punches
quaiches2235343quaiches
quenches2236013quenches
races74943243_ra_c_es
rachet115028973_ra_chet
rachets124516833_ra_chets
rachis114017653_ra_chis
rance75028513_ranc_e_
ranch105019793_ranch__
ranchero13277423_ranchero
rancheros14255793_rancheros
ranchless1444453_ranchless
ranchmen1545833_ranchmen
rancho114310853_ranch_o
rancors9811373_rancors
randies84225663_randies
ranees64623963_ran_ees
ranges73826923_ran_ges
rankles113114543_rankles
raphes115117453_ra_phes
rashes95330153_ra_shes
ratchet124218333_ratchet
ratchets133110263_ratchets
reaches123423203_reaches
rebranches1745193rebranches
retches123318513_retches
revanches1746253revanches
riches115022083_r_iches
roaches123616213_roaches
rotches123515703_rotches
rouches124217893_rouches
ruches114819583_r_uches
scraiched1744203scraiched
scraichs1543993scraich_s
scratched1735393scratched
scratcher1635443scratcher
scratchers1744293scratchers
screeches1695643screeches
scrooches1645703scrooches
scrunched1744033scrunched
scrunchies1744353scrunchies
seances93015343seanc_es
searches132112903searches
slatches131511523slatches
snatches131410713snatches
stances93715963stanc_es
stanched14208903stanched
stancher13198813stancher
stanchers14206813stanchers
stanchest14218213stanchest
starches131912913starches
staunches1444603staunches
stenches132110293stenches
swatches16169963swatches
taches114224173_ta_ches
teaches122718353tea_ches
tenches123515523_tenches
thatches1637513thatches
traces85329933tra_c_es
trachea12311673tra_chea
tracheas13410273tra_cheas
trachles13311753tra_chles
trance84718763tranc_e_
tranced104414173tranc_ed
trannies8415013trannies
trashes104119263tra_shes
trauchles1445493trauchles
trenched14289853trenched
trencher13279313trencher
trenchers14288073trenchers
troches123715343tr_oches
truancies1146883truancies
uranides92211283uranides
uranites82514643uranites
usances967373usanc_es
watches153017373_watches
wenches152914133_wenches
winches154714373_winches
wrangles1237463wrangles
wrenched17748133wrenched
wrencher16287783wrencher
wrenchers17256333wrenchers
wretches16257283wretches

Search took 10 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.1701051123.5
2DLD Change Limit1461624079.26615774.0
3Display Results4074070.1562609.0
 (SQL Overall)1786914079.59218629.2
 
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.