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

446 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
cranch13361353(None) 
branch134014771branch
cratch134110791cratch
craunch1464441craunch
crunch13349501crunch
ranch105019791_ranch
blanch133410852blanch
brach126123302bra_ch
branchy17357912branchy
brunch13329352brunch
cancha134411612c_ancha
caroch13911762caroch
catch125120372c_atch
chance134617092chance
chancy164010862chancy
chinch163911222chinch
cinch124516242c_inch
clach124617822cla_ch
clench133910052clench
clinch133910352clinch
coach125919452coa_ch
conch124620072c_onch
crack134120532cra_ck
cranched163210412cranched
cranches153114542cranches
crane75331602cran_e
craned96121652craned
cranes84330752cranes
crania82418432crania
crank114819612cran_k
cranks125015312cranks
cranky153910632cranky
cranny114210272cranny
crash109120012cra_sh
crotch133410082crotch
crouch133910202crouch
crunchy17324762crunchy
crutch13408242crutch
drench12369592drench
franc104615412franc_
francs114112192francs
french143511212french
grinch1238472grinch
orach105219232ora_ch
planch133711442planch
prance104318572prance
rance75028512_rance
rancho114310852_rancho
ratch104221362_ratch
raunch11358432_raunch
scraich1436762scraich
scratch1446012scratch
scrunch1444032scrunch
stanch113812372stanch
trance84718762trance
tranche123312222tranche
trench114211612trench
wrench14439352wrench
anarch11310393anarch
ancho104515303__ancho
ankh111114413__ankh
arch98628443__arch
bach116131393_ba_ch
banco94019393_banco
batch124620103_batch
beach124623893bea_ch
bench125619503_bench
blench133710453blench
brace95629273bra_ce
brachs134415753bra_chs
bract96332723bra_ct
bran65740383bran__
branched163210453branched
branches153613803branches
branchia15217713branchia
brand85124493bran_d
brands95118943brands
brandy124712063brandy
brank115222283bran_k
branks124817383branks
branny115111833branny
brans75437433bran_s
brant74742173bran_t
brants85723053brants
brash106221563bra_sh
breach134213723breach
breech13348263breech
broach133611113broach
bronc91714343bronc_
bronchi14176313bronchi
broncho14206463broncho
bronco10179493bronco
broncs101611153broncs
brooch13368443brooch
bunch125118603_bunch
caca85528083c_a_ca
cache125122483c_a_che
caeca93915133c_aeca
can57760133c_an__
canal75428043c_anal
cancan10314103c_ancan
cancel105316683c_ancel
cancer104220923c_ancer
canchas143212403c_anchas
candy115119823c_andy
cane66653113c_an_e
caned85838093c_aned
caner75334773c_aner
canes75350373c_anes
canid85526343c_anid
canna75919333c_anna
canny105817693c_anny
canoe75627253c_anoe
canon74725303c_anon
cans65050843c_an_s
canso75019403c_anso
canst74932213c_anst
cant66362023c_an_t
canthi11310963c_anthi
canto74931013c_anto
cants77036943c_ants
canty105226803c_anty
caph116623293c_a_ph
carack142113173carack
carn66245433carn__
carnal83919203carnal
carnet84732873carnet
carney115315703carney
carnie84421093carnie
carns75937563carn_s
carny105822923carn_y
caroach1488863caroach
caroche1469243caroche
carroch1437093carroch
cash96636283c_a_sh
catchy16559583c_atchy
chalah143511653chalah
chaleh143711993chaleh
chanced154113213chanced
chancel144011773chancel
chancer144215633chancer
chances145218093chances
chancre14348783chancre
chang115418563chan_g
change124116753change
changs125215373changs
chant105932693chan_t
chants115020393chants
chanty145215823chanty
chinchy20335513chinchy
church1636483church
clachs133511323cla_chs
clack134720173cla_ck
clan65633923clan__
clang86019313clan_g
clangs95113613clangs
clank114719523clan_k
clanks124615183clanks
clanky15469073clanky
clans75031013clan_s
clash106219033cla_sh
claucht1445583claucht
clutch13367753clutch
coact96130573coa_ct
coanchor1545243coanchor
concha134213283c_oncha
concho134414263c_oncho
conchs134714903c_onchs
conchy163710223c_onchy
cooch124916833c_ooch
coranto9311893coranto
coronach1545763coronach
couch125320113c_ouch
craal74117753cra_al
craals84113303craals
crab85727673cra__b
crabby15346753crabby
crabs95421393cra_bs
cracks144817003cracks
cracky175010223cracky
cradle93313163cradle
craft105327663cra_ft
crafts115312743crafts
crafty14478913crafty
crag75625303cra__g
craggy13396603craggy
crags85622573cra_gs
crake114823523cra_ke
crakes124921813crakes
cram85635493cra__m
crambe1239073crambe
crambo1238043crambo
cramp115120693cra_mp
cramps125615563cramps
crampy154710993crampy
crams96229153cra_ms
cranching17278733cranching
cranial92114683cranial
craning103620303craning
cranium11911103cranium
cranked143812843cranked
cranker133612783cranker
crankish1736513crankish
crankle133610063crankle
crankly16358123crankly
crannog1044243crannog
cranreuch1651023cranreuch
crap85731843cra__p
crape96128443cra_pe
craped116120523craped
crapes104727693crapes
crappy15446803crappy
craps95328643cra_ps
crases85532313crases
crasis85020473crasis
crass76328043cra_ss
cratches153012543cratches
crate76537403cra_te
crated94827773crated
crater85026633crater
crates85736053crates
craton84517193craton
craunched1764023craunched
craunches1655723craunches
cravat11314443cravat
crave105626313cra_ve
craved125417773craved
craven114113933craven
craver114618463craver
craves115825393craves
craw97725263cra__w
crawl104916713cra_wl
crawls114712083crawls
crawly144610763crawly
craws105723123cra_ws
crayon114110003crayon
craze165221463cra_ze
crazed184714453crazed
crazes174720133crazes
crazy195511223cra_zy
creche13310763cr_eche
creesh11328333creesh
crenel84213063crenel
crick135118753cr_ick
cringe93515483cringe
crinum1039333crinum
croc85723733cr_oc_
croci95818133cr_oci
crock135921993cr_ock
crocs95722433cr_ocs
crone75231333cron_e
crones84729243crones
cronish12310863cronish
crony105918673cron_y
cruck135615323cr_uck
crunched16328163crunched
cruncher15338073cruncher
crunches153711353crunches
crush106815993cr_ush
crwth1337483cr_wth
culch124512833c_ulch
cultch13385953cultch
curacy1339593cura_cy
curagh1236553cura_gh
curch124415413c_urch
currach1446453currach
cutch125116193c_utch
cyan96419623cyan__
cyanic133110773cyanic
cyanid123912033cyanid
cyanin113911453cyanin
cyano105512493cyan_o
cyans105714813cyan_s
dance85223133_dance
drachm1436493dra_chm
drank104816203dran_k
dreich12377723dreich
dunch115316263_dunch
durance1059113durance
each95530583_ea_ch
eparch13258423eparch
errancy1256363errancy
exarch18196173exarch
fancy134615483_fancy
fiance11310743fiance
finch135416973_finch
flench144010813flench
flinch144010103flinch
frank124417513fran_k
franks134912733franks
glance94312313glance
glunch1255353glunch
grace85124543gra_ce
gran56335013gran__
grana65722093gran_a
grand75122693gran_d
grands84218243grands
grange83716203grange
granny104311163granny
grans64832543gran_s
grant64840023gran_t
grants73722473grants
granum9310913granum
graph115315613gra_ph
grouch12318473grouch
grutch12285563grutch
hance105424153_hance
hatch135719593_hatch
haunch14377343haunch
hunch136416213_hunch
inarch1139163inarch
inch95420823__inch
kench145513923_kench
klatch15445933klatch
laich105920713_laich
lance75126723_lance
larch105919793_larch
latch104620463_latch
launch11368063launch
leach105422523lea_ch
loach105116363loa_ch
lunch104917243_lunch
lynch13468983_lynch
mach116134473_ma_ch
manche133515103_manche
march125622893_march
match125621103_match
munch124917103_munch
nance74721843_nance
nancy105214923_nancy
natch105018223_natch
nuance859043nuance
orache114013593ora_che
orang65119943oran_g
orange74016323orange
orangs74116033orangs
orangy105111233orangy
painch133511323painch
parch125123003_parch
patch125221223_patch
paunch13369853paunch
peach125422493pea_ch
pinch125619303_pinch
planche14299753planche
plench134010813plench
poach124917863poa_ch
pranced123714043pranced
prancer113613383prancer
prances113618773prances
prang84820323pran_g
prangs94816233prangs
prank115019453pran_k
pranks124814723pranks
preach133613923preach
prince104114763prince
punch125118423_punch
quaich2047693quaich
quench2036633quench
race66746263_ra_ce
rack106234883_ra_ck
racy95825683_ra_cy
rah68052403_ra__h
rajah155711423_rajah
ralph1078743_ralph
ran38266613_ran__
rances84625443_rances
ranched133113603_ranched
rancher123013633_rancher
ranches123620113_ranches
ranchos123911393_ranchos
rancid9513863_rancid
rancor8810373_rancor
rand55839563_ran_d
rands65930453_rands
randy95022083_randy
ranee55438103_ranee
rang56939153_ran_g
range64728413_range
rangy95320383_rangy
rani46640103_ran_i
ranid66429333_ranid
ranis55235833_ranis
rank85135523_ran_k
ranks95225733_ranks
rant45864673_ran_t
rants55935343_rants
rash76039933_ra_sh
rath76037663_ra_th
raunchy15284313_raunchy
rayah116013503_rayah
reach105123883_reach
rebranch1545793rebranch
retch104818303_retch
rich97025543_r_ich
roach105717003_roach
rotch105815933_rotch
sangh95517453_sangh
sauch104918773_sauch
scraichs1543993scraichs
scraigh1335673scraigh
scratchy1843653scratchy
screech1435213screech
scrooch1444953scrooch
scrunchy1852383scrunchy
seance83716683seance
search113312423search
slatch114510533slatch
snatch114310603snatch
stance84316913stance
starch113013203starch
staunch1244273staunch
stench114111163stench
swatch14549283swatch
synch135011793_synch
tach96132753_ta_ch
teach105221123tea_ch
tench105620003_tench
thatch1435603thatch
trace75829613tra_ce
track114823013tra_ck
tract75635713tra_ct
tranced104414173tranced
trances93919643trances
tranches132915513tranches
trank96222423tran_k
tranks104017763tranks
tranny94210863tranny
tranq145416893tran_q
tranqs155210313tranqs
trans54933043tran_s
trash86119763tra_sh
truancy1244993truancy
urania62516123urania
uranic82315183uranic
uranyl936293uranyl
usance858013usance
watch135617063_watch
wench136214783_wench
winch135016663_winch
wrack145413883wra_ck
wraith1258603wraith
wrang94716113wran_g
wrangs104611913wrangs
wrath115715873wra_th
wretch14326533wretch
xerarch1943843xerarch

Search took 6 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 Filter1786911127160.1401276364.3
2DLD Change Limit1127164464.84323274.0
3Display Results4464460.1433118.9
 (SQL Overall)1786914465.12634859.7
 
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.