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

293 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
cranched16321041(None) 
branched163210451branched
cranches153114541cranches
craunched1764021craunched
crunched16328161crunched
ranched133113601_ranched
blanched16308602blanched
branches153613802branches
brunched16317852brunched
cached145419202c_a_ched
chanced154113212chanc_ed
cinched153910862c_inched
clenched16257762clenched
clinched16347382clinched
coached153313842coa_ched
cracked163514742cra_cked
cranch133613532cranch__
craned96121652cran__ed
cranked143812842cran_ked
crankled15408152crankled
crannied1137902crannied
crashed134214212cra_shed
cratches153012542cratches
craunches1655722craunches
crotched16428602crotched
crouched16359152crouched
cruncher15338072cruncher
crunches153711352crunches
crutched16307462crutched
drenched15247912drenched
frenched17299432frenched
pranced123714042pranc_ed
rancher123013632_rancher
ranches123620112_ranches
scraiched1744202scraiched
scratched1735392scratched
scrunched1744032scrunched
stanched14208902stanched
tranced104414172tranc_ed
tranche123312222tranche_
tranches132915512tranches
trenched14289852trenched
wrenched17748132wrenched
ached119227833__a_ched
arched125717323__arched
bached145519893_ba_ched
batched154114243_batched
beached154516553bea_ched
benched154713943_benched
blancher15338633blancher
blanches153311603blanches
blenched16358053blenched
braced115420603bra_c_ed
braches144621223bra_ches
brachet144020313bra_chet
bracted12410933bra_cted
branch134014773branch__
branchia15217713branchia
branchier1637133branchier
branchlet1647183branchlet
branchy17357913branch_y
branded114414103bran_ded
brandied1259113brandied
branned104311693bran_ned
breached163411643breached
breeched16337383breeched
broached16309123broached
bruncher15347783bruncher
brunches153710453brunches
bunched154312413_bunched
caboched1844043caboched
cache125122483c_a_che_
caches137926913c_a_ches
cachet134526413c_a_chet
canaled103615563c_analed
cancel105316683c_anc_el
canceled13279403c_anceled
cancer104220923c_anc_er
cancered132411553c_ancered
cancha134411613c_anch_a
canchas143212403c_anchas
candied113816023c_andied
candled113815743c_andled
caned85838093c_an__ed
canned95022063c_an_ned
canoed94618963c_an_oed
canted94825783c_an_ted
capuched1843743capuched
caroche1469243caroche_
caroches15710693caroches
cashed125124353c_a_shed
catcher143115823c_atcher
catches144320773c_atches
chance134617093chanc_e_
chancel144011773chanc_el
chancer144215633chanc_er
chances145218093chanc_es
chancier1538823chancier
chancre14348783chancre_
chancres15429363chancres
changed144214143chan_ged
chanted134015953chan_ted
chinches18369363chinches
churched1934653churched
cinches144215773c_inches
clacked164113603cla_cked
clanged114212653clan_ged
clanked143812253clan_ked
clashed133614013cla_shed
clencher15277973clencher
clenches152910953clenches
cliched153711023c_liched
clincher15347663clincher
clinches153910363clinches
clutched16356033clutched
coacher143714123coa_cher
coaches144018693coa_ches
coacted123611613coa_cted
coalshed1435013coalshed
coanchor1545253coanchor
coanchored1843273coanchored
conches144019813c_onches
couched154115793c_ouched
craaled10339423cra_aled
crabbed14388873cra_bbed
cracker153114173cra_cker
crackhead2143323crackhead
crackled17428863crackled
cradled113410813cra_dled
crafted13419773cra_fted
cragged12479883cra_gged
crammed143710123cra_mmed
cramped144712183cra_mped
cranching17278733cranching
crane75331603cran__e_
cranes84330753cran__es
cranker133612793cran_ker
crankier14339163crankier
crankle133610063crankle_
crankles143510153crankles
crannies10313013crannies
craped116120533cra__ped
crapped143912633cra_pped
crasher124616163cra_sher
crashes124618403cra_shes
cratch134110793cratch__
crated94827773cra__ted
cratered1149683cratered
craunch1464443craunch__
craved125417773cra__ved
cravened1476723cravened
crawled133710403cra_wled
crayoned1435003crayoned
crazed184714453cra__zed
creche13310763cr_eche_
creches14313093cr_eches
creeshed1435703creeshed
crenated113013913crenated
creneled11326893creneled
cricked164814283cr_icked
cringed113312403crin_ged
crinkled15357153crinkled
crochet143616663cr_ochet
crocked164014443cr_ocked
crotches153411303crotches
crotchet152711993crotchet
crouches153711293crouches
crunch13349503crunch__
crunchers16316243crunchers
crunchier1644683crunchier
crunchy17324763crunch_y
crushed134111973cr_ushed
crutches15359593crutches
cyanided15254893cyanided
cyanosed1444613cyanosed
danced105315253_danc_ed
drencher14257213drencher
drenches14309803drenches
fancied133310603_fancied
flenched17267963flenched
flinched17316703flinched
fracted1339373fra_cted
franchised1943963franchised
francized2445583francized
franked153610053fran_ked
frenches163311633frenches
glanced11439233glanc_ed
glunched1544263glunched
graced105217903gra_c_ed
granted94715103gran_ted
graphed1498473gra_phed
grinches1436953grinches
grouched15356663grouched
grutched15284673grutched
hatched163414463_hatched
haunched1744813haunched
hunched163710493_hunched
inarched1486113inarched
inched124514483__inched
lanced93717723_lanc_ed
latched133914073_latched
launched1475403launched
leached133715043lea_ched
lunched133911823_lunched
lynched16376753_lynched
manche133515103_manche_
manches143818623_manches
manchet143317783_manchet
marched153813403_marched
matched153513963_matched
munched153411073_munched
nuanced1036203nuanc_ed
orache114013593ora_che_
oraches124216473ora_ches
parched154013693_parched
patched153514623_patched
paunched1645523paunched
peached154315883pea_ched
pinched153812453_pinched
planche14299753planche_
planches153111863planches
planchet152511963planchet
poached154212403poa_ched
prance104318573pranc_e_
prancer113613383pranc_er
prances113618773pranc_es
pranged114512553pran_ged
pranked143712093pran_ked
preached163412063preached
punched153512173_punched
quenched2334103quenched
raced87635313_ra_c_ed
rachet115028973_ra_chet
racked134526083_ra_cked
ralphed1334363_ralphed
rance75028513_ranc_e_
rances84625443_ranc_es
ranch105019793_ranch__
ranchero13277423_ranchero
ranchers133311793_ranchers
ranchmen1545833_ranchmen
rancho114310853_ranch_o
ranchos123911393_ranchos
rancid9513863_ranc_id
rancored1137233_rancored
ranged84824323_ran_ged
ranked114620743_ran_ked
rankled123910653_rankled
ranted74324703_ran_ted
ratches123620463_ratches
ratchet124218333_ratchet
raunches1368053_raunches
reached134619083_reached
rebranched1843673rebranched
retched133814273_retched
roached133211833_roached
ruched124314633_r_uched
scraighed1643593scraighed
scratcher1635443scratcher
scratches1647323scratches
screeched17114343screeched
scrooched1763853scrooched
scrunches1635403scrunches
searched14209253searched
snatched14157633snatched
stancher13198813stancher
stanches132312793stanches
starched14199313starched
staunched1553473staunched
synched16277213_synched
thatched1735433thatched
traced94821583tra_c_ed
trachea12311683tra_chea
tracheid1437583tra_cheid
trachled1438313tra_chled
tracked143716133tra_cked
trance84718763tranc_e_
trances93919643tranc_es
trashed113514703tra_shed
trauchled1543733trauchled
trencher13279313trencher
trenches133512603trenches
unarched14128553unarched
unbranched1843533unbranched
watched163012823_watched
wenched163910913_wenched
winched163110593_winched
wracked174110113wra_cked
wrangled1335593wrangled
wrathed14298523wra_thed
wrencher16287783wrencher
wrenches163210233wrenches
wretched17276533wretched

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 Limit1461622937.04620744.0
3Display Results2932930.1262325.4
 (SQL Overall)1786912937.62523434.9
 
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.