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

359 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
clinch13391035(None) 
chinch163911221chinch
cinch124516241c_inch
clench133910051clench
flinch144010101flinch
blanch133410852blanch
blench133710452blench
chinchy20335512chinchy
clach124617822cl_ach
cliche133712452cli_che
click135217952cli_ck
clinal8311552clinal
clinched16347382clinched
clincher15347662clincher
clinches153910362clinches
cline76428532clin_e
clines84926042clines
cling86424672clin_g
clings95716212clings
clingy12659062clingy
clinic104312792clinic
clinics11338742clinics
clink115320042clin_k
clinks125815062clinks
clutch13367752clutch
conch124620072c_onch
cranch133613532cranch
crunch13349502crunch
finch135416972_finch
flench144010812flench
flitch14928172flitch
glitch12286352glitch
glunch1255352glunch
grinch1238472grinch
inch95420822__inch
lich96230842_li_ch
lunch104917242_lunch
lynch13468982_lynch
painch133511322painch
pinch125619302_pinch
planch133711442planch
plench134010812plench
plinth11310452plinth
unclinch1544872unclinch
winch135016662_winch
aclinic11188973aclinic
aitch105216163_aitch
aline57243153alin_e
alined75221403alined
aliner65621983aliner
alines65735223alines
aliyah12397493aliyah
alnico877943alnico
bench125619503_bench
birch124914023_birch
bitch125017763_bitch
bleach133611403bleach
blin67228173blin__
blind86319323blin_d
blinds95111613blinds
blini75519273blin_i
blinis85313683blinis
blink115720143blin_k
blinks124613573blinks
blintz1788843blintz
blotch13197143blotch
branch134014773branch
brunch13329353brunch
bunch125118603_bunch
cain65643913cain__
cains75334303cain_s
caliche14329953cali_che
calico103414433cali_co
caliph13311403cali_ph
cancha134411613c_ancha
caroch13911763caroch
catch125120373c_atch
celiac101910433celiac_
celiacs11157893celiacs
chance134617093chance
chancy164010863chancy
chic115925203chi_c_
chica125818263chi_ca
chichi1637093chi_chi
chick165419133chi_ck
chico124218253chi_co
chics123920943chi_cs
chin96934743chin__
china105022473chin_a
chinas115119383chinas
chinches18369363chinches
chine105231723chin_e
chined125620063chined
chines115029173chines
chink145321593chin_k
chinks155817573chinks
chinky185610543chinky
chino105823313chin_o
chinos115018693chinos
chins105631463chin_s
chints115117833chints
chintz204212023chintz
church1636483church
cilice103213353cilice
cinched153910863c_inched
cinches144215773c_inches
cine66242943c_in_e
cines75239683c_ines
circa9311403c_irca
cisco95112133c_isco
clachs133511323cl_achs
clack134720173cl_ack
clan65633923clan__
clang86019313clan_g
clangs95113613clangs
clank114719523clan_k
clanks124615183clanks
clanky15469073clanky
clans75031013clan_s
clash106219033cl_ash
claucht1445583claucht
clenched16257763clenched
clencher15277973clencher
clenches152910953clenches
cliched153711023cli_ched
cliches144213743cli_ches
clicks145315113clicks
client8316343client
clients938093clients
cliff135917133cli_ff
cliffs14477593cliffs
cliffy17435243cliffy
clift106422193cli_ft
clifts11519153clifts
climax1735653climax
climb115413593cli_mb
climbs12498723climbs
clime95720893cli_me
climes104720003climes
clinchers16336263clinchers
clinching17276123clinching
clinged113310093clinged
clinger103812153clinger
clinical1247023clinical
clinked144011643clinked
clinker133811663clinker
clip86924003cli__p
clips96018303cli_ps
clipt96324273cli_pt
clique17289193clique
cliquy20324713cliquy
clitic103315053clitic
clitics11279973clitics
clivia1177233clivia
cloaca1037263cloaca
cloche134312373cl_oche
clock134917983cl_ock
clon66232483clon__
clonal8310913clonal
clone75728163clon_e
cloned94518803cloned
cloner84418093cloner
clones84526563clones
clonic104914673clonic
clonk114417443clon_k
clonks125013473clonks
clons75228133clon_s
clonus85212413clonus
cloth105817543cl_oth
clough12539133clough
cluck134914893cl_uck
cluing93913503cluin_g
clung86013603clun_g
clunk114215083clun_k
clunks124811013clunks
clunky15447893clunky
clutchy17323893clutchy
coach125919453c_oach
coin66645353coin__
coined94523603coined
coiner84323783coiner
coins75834553coin_s
colic95726173coli_c_
colics104219903coli_cs
colin76231693colin__
colins85229043colin_s
concha134213283c_oncha
concho134414263c_oncho
conchs134714903c_onchs
conchy163710223c_onchy
conic95329793conic_
conics103920593conics
cooch124916833c_ooch
couch125320113c_ouch
cratch134110793cratch
craunch1464443craunch
crick135118753cri_ck
cringe93515483cringe
crinum1039333crinum
crotch133410083crotch
crouch133910203crouch
crunchy17324763crunchy
crutch13408243crutch
cuing85420193cuin_g
cuish10313173cui_sh
culch124512833c_ulch
cultch13385953cultch
curch124415413c_urch
cutch125116193c_utch
cynic124712423cynic_
cynics13377363cynics
ditch115015093_ditch
drench12369593drench
dunch115316263_dunch
elenchi1244713elenchi
elint55436473elin_t
elints65816423elints
evince1137763evince
filch134813323_filch
finca104714503_finca
fitch134816873_fitch
fleech14367343fleech
fletch14388193fletch
flic96223733fli_c_
flick145017213fli_ck
flics105418363fli_cs
flinched17316703flinched
flincher16256583flincher
flinches16358953flinches
fling97023513flin_g
flings106715283flings
flint87333503flin_t
flints95617453flints
flinty126112493flinty
flysch1732893flysch
french143511213french
glance94312313glance
glint66830183glin_t
glints75714213glints
glinty106910693glinty
glitchy16283083glitchy
haunch14377343haunch
hitch134515473_hitch
hunch136416213_hunch
ich86227743__i_ch
iliac75013493iliac_
itch95619173__itch
kench145513923_kench
klatch15445933klatch
klick105311433kli_ck
laich105920713_laich
lance75126723_lance
larch105919793_larch
latch104620463_latch
launch11368063launch
leach105422523_leach
lech96825443_l_ech
leech104913213_leech
letch105215803_letch
lice66045063_li_ce
lichi104412953_li_chi
licht104723493_li_cht
lick106935073_li_ck
lin37967373_lin__
linac7315413_linac
linacs8310813_linacs
lindy96918313_lindy
line46965573_lin_e
lined64934643_lined
linen55728723_linen
liner55938923_liner
lines57054573_lines
liney87029633_liney
ling57447963_lin_g
linga66820813_linga
lingo66022113_lingo
lings67135773_lings
lingy96925143_lingy
linin58025523_linin
link86943443_lin_k
links96430193_links
linky127622383_linky
linn46034593_lin_n
linns56123333_linns
lino46343373_lin_o
linos55631503_linos
lins47059053_lin_s
lint416266233_lin_t
lints57137193_lints
linty87126563_linty
linum7313823_linum
liny78141323_lin_y
litchi1137893_litchi
loach105116363_loach
loch95527133_l_och
lurch104814633_lurch
lych126015763_l_ych
milch124413373_milch
mince95325233_mince
mincy125817413_mincy
munch124917103_munch
ninth8314583_ninth
olingo736933olingo
paunch13369853paunch
pitch125018413_pitch
planche14299753planche
pleach134211243pleach
pliancy1435593pliancy
plica9613373pli_ca
plink115219123plin_k
plinks124913263plinks
plinths1236123plinths
prince104114763prince
punch125118423_punch
quench2036633quench
quince173910133quince
quitch2036413quitch
ranch105019793_ranch
raunch11358433raunch
rich97025543_ri_ch
scrunch1444033scrunch
since75024173_since
sinh76238043_sin_h
slatch114510533slatch
slice74925823sli_ce
slick115520523sli_ck
sling66028803slin_g
slings74618013slings
slink95422913slin_k
slinks104315153slinks
slinky13399103slinky
slouch11438523slouch
smirch1356463smirch
snitch11357943snitch
spinach1435393spinach
squinch2134833squinch
stanch113812373stanch
stench114111163stench
stich104117923sti_ch
stitch11419103stitch
switch14458913switch
synch135011793_synch
tench105620003_tench
tinct76126233_tinct
trench114211613trench
twitch14406163twitch
unclench1544143unclench
vinca105315163_vinca
wench136214783_wench
which163910083whi_ch
wich125724743_wi_ch
wince105220883_wince
witch134517563_witch
wrench14439353wrench
yince105214253_yince
zilch19438123_zilch
zinc156819093_zinc_
zincs165312933_zincs
zincy195413513_zincy

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 Filter1786911127160.1401276364.3
2DLD Change Limit1127163596.18618221.1
3Display Results3593590.1103263.6
 (SQL Overall)1786913596.43627764.3
 
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.