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

329 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
blanches15331160(None) 
blanched16308601blanched
blancher15338631blancher
blanchers16307431blanchers
blenches153310761blenches
branches153613801branches
planches153111861planches
baches135426942b_a_ches
balances1279972balanc_es
batches144019612b_atches
beaches144120652bea_ches
benches143918602b_enches
blanch133410852blanch__
bleaches153410672bleaches
blenched16358052blenched
blencher15308392blencher
blenchers16356722blenchers
blotches1537432blotches
braches144621222bra_ches
branched163210452branched
brunches153710452brunches
bunches144116032b_unches
clenches152910952clenches
clinches153910362clinches
cranches153114542cranches
flenches163410532flenches
flinches16358952flinches
glances104113142glanc_es
glunches1436262glunches
klatches17157132klatches
laches116528342_la_ches
lances84824102_lanc_es
larches124416442_larches
latches123320122_latches
launches1387902_launches
lunches124115442_lunches
lynches15378872_lynches
manches143818622_manches
planche14299752planche_
planchet152511962planchet
planchets16236742planchets
plenches153110622plenches
ranches123620112_ranches
slatches131511522slatches
stanches132312792stanches
tranches132915512tranches
aches106132293__a_ches
alanines8314803alanines
anchos114214893__anchos
apaches143411833apa_ches
arches114822043__arches
avalanches18102843avalanches
babiches1735253babiches
bached145519893b_a_ched
balance11510263balanc_e_
balanced1356513balanc_ed
balancer1246603balanc_er
balancers1345063balancers
bancos104713893b_anc_os
bandies104124863b_andies
banes74945583b_an__es
bangles103617413b_angles
banishes131812463b_anishes
banjoes16317313b_anjoes
banshee121212453b_anshee
banshees13127863b_anshees
banshies131110663b_anshies
banties94324763b_anties
bashes115631393b_a_shes
batched154114243b_atched
batcher144414853b_atcher
batchers153613273b_atchers
bathes116524833b_a_thes
beached154516553bea_ched
beanies93821093bean_ies
beeches143413883b_eeches
belches143514343b_elches
benched154713943b_enched
bencher144113483b_encher
benchers153611013b_enchers
birches143412323b_irches
bitches144117063b_itches
blacked163613373bla_cked
blacken15439793bla_cken
blackens16388103bla_ckens
blacker154513513bla_cker
blackest16269303bla_ckest
blacks144914953bla_c_ks
blades95221253bla__des
blahs105616513bla__h_s
blames105121863bla__mes
blanching17297093blanching
blander103715163blan_der
blandest113811043blan_dest
blandishes1644613blandishes
blandness1235973blandness
blanked144011223blan_ked
blanker134612023blan_ker
blankest14439063blan_kest
blanket134313093blan_ket
blankets14356503blankets
blankness1544673blankness
blanks124112893blan__ks
blares85021633bla__res
blasties102113623blasties
blatancies1444373blatancies
blather125314203bla_ther
blathers134713793bla_thers
blazes174817353bla__zes
bleached16378563bleached
bleacher15358883bleacher
bleachers16297923bleachers
blench133710453blench__
blendes104713683blen_des
blennies1056933blennies
blintzes1944263blintzes
blondes104213163blon_des
blotched1635653blotched
blucher143310223bl_ucher
bluchers15359033bl_uchers
blunges104212223blun_ges
blushes124314823bl_ushes
bobeches1744483bobeches
boches134618523b__oches
borsches1536003borsches
botches143716023b_otches
bounces113813683bounc_es
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
bunched154312413b_unched
butches144315363b_utches
bycatches2142683bycatches
caches137926913_ca_ches
caleches15269933caleches
caliches153812263caliches
canchas143212403_canchas
catches144320773_catches
chances145218093chanc_es
chancres15429363chancres
chinches18369363chinches
cinches144215773_cinches
clachs133511323cla_ch_s
clashes124017283cla_shes
clenched16257763clenched
clencher15277973clencher
clenchers16276553clenchers
cliches144213743cl_iches
clinched16347383clinched
clincher15347663clincher
clinchers16336263clinchers
cloches144113713cl_oches
clutches15307923clutches
coaches144018693coa_ches
conches144019813_conches
cranched163210413cranched
cratches153012543cratches
craunches1655723craunches
crunches153711353crunches
dances95120653_danc_es
drenches14309803drenches
dunches133312583_dunches
elenchus1343633elenchus
fancies124018783_fancies
fiancees1335103fiancees
fiances12310673fianc_es
finches153914193_finches
flanes94522423flan__es
flanges113413273flan_ges
flashes133916103fla_shes
fleches153411443fl_eches
fleeches16287083fleeches
flenched17267963flenched
fletches16308853fletches
flinched17316703flinched
flincher16256583flincher
flinchers17295473flinchers
flitches16388463flitches
flysches1933123flysches
frenches163311633frenches
ganaches1437413_ganaches
glaces94218023gla_c_es
glance94312313glanc_e_
glanced11439233glanc_ed
glancer103710073glanc_er
glancers11408003glancers
glandes95413833glan_des
glitches14296653glitches
glunched1544263glunched
grinches1436943grinches
hances115621283_hanc_es
hatches153420273_hatches
haunches1656963haunches
hunches153913463_hunches
inarches1358043inarches
inches114419673__inches
kalanchoes1951843kalanchoes
kenches163912273_kenches
klatsches1842223klatsches
laces76141763_la_c_es
laichs115110893_laich_s
lance75126723_lanc_e_
lanced93717723_lanc_ed
lancer84319973_lanc_er
lancers93616643_lancers
lancet84223573_lanc_et
lancets93411163_lancets
lanciers10308543_lanciers
lanes54946793_lan__es
langues81211913_langues
larchen12479623_larchen
lashes94831003_la_shes
latched133914063_latched
latchet123117903_latchet
latchets133410013_latchets
lathes95127493_la_thes
launces9329003_launc_es
launched1475403_launched
launcher1365563_launcher
launchers1454333_launchers
leaches123319343_leaches
leches115421313_l_eches
leeches123911933_leeches
letches124015483_letches
liches114724293_l_iches
loaches123613983_loaches
lunched133911823_lunched
luncher123111413_luncher
lunchers13349563_lunchers
lurches123311663_lurches
lyches144213613_l_yches
lynched16376753_lynched
lyncher15366553_lyncher
lynchers16285453_lynchers
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
oraches124216473ora_ches
painches1588913painches
panaches15310283_panaches
panoches1548123_panoches
parches143720003_parches
patches143320383_patches
paunches1568173paunches
peaches144120053pea_ches
pinches144117933_pinches
places104323703pla_c_es
plaices11411143plaic_es
planch133711443planch__
planes85028083plan__es
planishes14138523planishes
plashes124417393pla_shes
pleaches153210433pleaches
pliancies1346673pliancies
poaches144416943poa_ches
prances113618773pranc_es
punches144816133_punches
quaiches2235343quaiches
quenches2236013quenches
rances84625443_ranc_es
ranched133113603_ranched
rancher123013633_rancher
ranchers133311793_ranchers
ranchos123911393_ranchos
ratches123620463_ratches
raunches1368053raunches
reaches123423203rea_ches
rebranches1745193rebranches
relaunches1543443relaunches
revanches1746253revanches
roaches123616213roa_ches
seances93015343seanc_es
searches132112903searches
slashes103619103sla_shes
slouches13208073slouches
snatches131410713snatches
stances93715963stanc_es
stanched14208903stanched
stancher13198813stancher
stanchers14206813stanchers
stanchest14218213stanchest
starches131912913starches
staunches1444603staunches
stenches132110293stenches
swatches16169963swatches
taches114224173_ta_ches
teaches122718353tea_ches
tenches123515523_tenches
thatches1637513thatches
trances93919643tranc_es
tranche123312223tranche_
trenches133512603trenches
unlatches1444293unlatches
usances967373usanc_es
valances1398763valanc_es
watches153017373_watches
wenches152914133_wenches
winches154714373_winches
wrenches163210233wrenches

Search took 9 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.1561145455.1
2DLD Change Limit1461623297.76618820.8
3Display Results3293290.1402350.0
 (SQL Overall)1786913298.06222164.6
 
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.