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

252 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
blancher1533863(None) 
blanched16308601blanched
blanchers16307431blanchers
blanches153311601blanches
blencher15308391blencher
balancer1246602balanc_er
batcher144414852b_atcher
bencher144113482b_encher
blacker154513512bla_cker
blanch133410852blanch__
blander103715162blan_der
blanker134612022blan_ker
blather125314202bla_ther
bleacher15358882bleacher
blenched16358052blenched
blenchers16356722blenchers
blenches153310762blenches
blucher143310222bl_ucher
branched163210452branched
branches153613802branches
branchier1637132branchier
bruncher15347782bruncher
clencher15277972clencher
clincher15347662clincher
flincher16256582flincher
glancer103710072glanc_er
lancer84319972_lanc_er
launcher1365562_launcher
luncher123111412_luncher
lyncher15366552_lyncher
planche14299752planche_
planches153111862planches
planchet152511962planchet
rancher123013632_rancher
stancher13198812stancher
anchor113911973__anchor
anther93715063__anther
archer115016243__archer
bached145519893b_a_ched
baches135426943b_a_ches
backer144525523b_a_cker
balance11510263balanc_e_
balanced1356513balanc_ed
balancers1345063balanc_ers
balances1279973balanc_es
bander93928223b_an_der
banger94423633b_an_ger
banisher13169183b_anisher
banker124222733b_an_ker
banner84421503b_an_ner
banshee121212453b_anshee
banter84825333b_an_ter
basher115123813b_a_sher
batched154114243b_atched
batchers153613273b_atchers
batches144019613b_atches
bather115322513b_a_ther
beached154516553bea_ched
beaches144120653bea_ches
beachier1538803bea_chier
belcher143511493b_elcher
benched154713943b_enched
benchers153611013b_enchers
benches143918603b_enches
bilander1136673bilan_der
blabber10418923bla_bber
blacked163613373bla_cked
blacken15439793bla_cken
bladder11429153bla_dder
blader93618583bla__der
blamer104417143bla__mer
blanching17297093blanching
blandisher1643463blandisher
blanked144011223blan_ked
blanket134313093blan_ket
blaster94017303bla_ster
blastier10249493blastier
blathers134713793bla_thers
blatter94415653bla_tter
blazer174414023bla__zer
blazoner1944133blazoner
bleached16378563bleached
bleachers16297923bleachers
bleaches153410673bleaches
blench133710453blench__
blender104613843blen_der
blether12459913bl_ether
blinder103912983blin_der
blinker134110213blin_ker
blither124812173bl_ither
blocker15419923bl_ocker
blonder104011943blon_der
blotched1635653blotched
blotches1537433blotches
blotchier1643213blotchier
bluchers15359033bl_uchers
blunder103813153blun_der
blunger104112013blun_ger
blunter94512033blun_ter
blusher124113113bl_usher
botcher143613223b_otcher
bouncer113811333bounc_er
bouncier1236033bouncier
bracer104620583bra_c_er
braches144621223bra_ches
brachet144020313bra_chet
branch134014773branch__
branchia15217713branchia
branchlet1647183branchlet
branchy17357913branch_y
brander103915823bran_der
branner94212373bran_ner
brannier10218933brannier
brasher124515243bra_sher
breacher153011503breacher
broacher15329263broacher
brunched16317853brunched
brunchers16296253brunchers
brunches153710453brunches
bunched154312413b_unched
bunches144116033b_unches
bunchier1536153b_unchier
butcher143411163b_utcher
cancer104220923_canc_er
catcher143115823_catcher
chancer144215633chanc_er
chancier1538823chancier
clacker153813773cla_cker
clanger104113493clan_ger
clankier14327083clankier
clasher124615513cla_sher
clenched16257763clenched
clenchers16276553clenchers
clenches152910953clenches
clinched16347383clinched
clinchers16336263clinchers
clinches153910363clinches
coacher143714123coa_cher
coanchor1545253coanchor
cranched163210413cranched
cranches153114543cranches
cruncher15338073cruncher
dancer94817613_danc_er
drencher14257213drencher
fancier123412063_fancier
flanger113412623flan_ger
flanker143911293flan_ker
flasher133914063fla_sher
flenched17267963flenched
flenches163410533flenches
fletcher16306663fletcher
flinched17316703flinched
flinchers17295473flinchers
flinches16358953flinches
gaucher1337233_gaucher
glacier103911293gla_cier
glance94312313glanc_e_
glanced11439233glanc_ed
glancers11408003glanc_ers
glances104113143glanc_es
glunched1544263glunched
glunches1436263glunches
hatcher153314723_hatcher
incher114114033__incher
klatches17157133klatches
lacer75833753_la_c_er
laches116528343_la_ches
lacier84020093_la_cier
lacker125325623_la_cker
lance75126723_lanc_e_
lanced93717723_lanc_ed
lancers93616643_lanc_ers
lances84824103_lanc_es
lancet84223573_lanc_et
lanciers10308543_lanciers
lander74028483_lan_der
landler84113203_landler
lanker104123003_lan_ker
lankier113711633_lankier
lanner64920603_lan_ner
larchen12479623_larchen
larches124416443_larches
lasher94824533_la_sher
latched133914063_latched
latches123320123_latches
latchet123117903_latchet
lather95124353_la_ther
laugher1136603_laugher
launched1475403_launched
launchers1454333_launchers
launches1387903_launches
leacher124014843_leacher
lecher113415853_l_echer
lunched133911823_lunched
lunchers13349563_lunchers
lunches124115443_lunches
lurcher12338133_lurcher
lynched16376753_lynched
lynchers16285453_lynchers
lynches15378873_lynches
manche133515103_manche_
manches143818623_manches
manchet143317773_manchet
marcher143912973_marcher
matcher143214283_matcher
muncher143610373_muncher
panther12611443_panther
patcher143515143_patcher
peacher144216073pea_cher
pincher143812713_pincher
placer105117743pla_c_er
planch133711443planch__
planchets16236743planchets
planer84122653plan__er
planisher1495853planisher
plankter1435363plankter
planner93511623plan_ner
planter94017803plan_ter
plasher124215033pla_sher
plenches153110623plenches
poacher143912323poa_cher
prancer113613383pranc_er
puncher143311673_puncher
quencher2234123quencher
ranched133113603_ranched
ranchero13277423_ranchero
ranchers133311793_ranchers
ranches123620113_ranches
reacher123718293rea_cher
searcher13209103searcher
slacker133915293sla_cker
slander84015443slan_der
slangier9117933slangier
slasher104515333sla_sher
slatches131511523slatches
slather103816073sla_ther
sloucher13206813sloucher
snatcher13167763snatcher
stanched14208903stanched
stanchers14206813stanchers
stanches132312793stanches
stauncher1443513stauncher
teacher123714833tea_cher
thatcher1635663thatcher
tranche123312223tranche_
tranches132915513tranches
trencher13279313trencher
unanchor1343093unanchor
watcher153113403_watcher
wencher153811133_wencher
wincher153410653_wincher
wrencher16287783wrencher

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.1701051123.5
2DLD Change Limit1461622527.34319904.9
3Display Results2522520.0962625.0
 (SQL Overall)1786912527.60923484.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.