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

254 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
blanched1630860(None) 
blancher15338631blancher
blanches153311601blanches
blenched16358051blenched
branched163210451branched
bached145519892b_a_ched
balanced1356512balanc_ed
batched154114242b_atched
beached154516552bea_ched
benched154713942b_enched
blacked163613372bla_cked
blanch133410852blanch__
blanchers16307432blanchers
blanked144011222blan_ked
bleached16378562bleached
blencher15308392blencher
blenches153310762blenches
blotched1635652blotched
branches153613802branches
brunched16317852brunched
bunched154312412b_unched
clenched16257762clenched
clinched16347382clinched
cranched163210412cranched
flenched17267962flenched
flinched17316702flinched
glanced11439232glanc_ed
glunched1544262glunched
lanced93717722_lanc_ed
latched133914062_latched
launched1475402_launched
lunched133911822_lunched
lynched16376752_lynched
planche14299752planche_
planches153111862planches
planchet152511962planchet
ranched133113602_ranched
stanched14208902stanched
ached119227833__a_ched
arched125717323__arched
avalanched19121713avalanched
baches135426943b_a_ches
backed155725723b_a_cked
balance11510263balanc_e_
balancer1246603balanc_er
balances1279973balanc_es
banded105223173b_an_ded
bandied114414303b_andied
baned85436353b_an__ed
banged104923723b_an_ged
banished14189063b_anished
banked135021443b_an_ked
banned94721343b_an_ned
banshee121212453b_anshee
bashed126225703b_a_shed
batcher144414853b_atcher
batches144019613b_atches
bathed125518743b_a_thed
beaches144120653bea_ches
beaned95621473bean__ed
belaced124112153bela_c_ed
belched154011843b_elched
bencher144113483b_encher
benches143918603b_enches
beuncled1334013beuncled
birched15349913b_irched
bitched153212923b_itched
blabbed11357813bla_bbed
blacken15439793bla_cken
blacker154513513bla_cker
blackhead2184293blackhead
bladed104717763bla__ded
blamed116017953bla__med
blanching17297093blanching
bland85320453blan___d
blander103715163blan_der
blandished1743333blandished
blanker134612023blan_ker
blanket134313093blan_ket
blanketed1643913blanketed
blared95018243bla__red
blarneyed1542153blarneyed
blasted104213473bla_sted
blather125314203bla_ther
blatted104812713bla_tted
blawed124713893bla__wed
blazed184314713bla__zed
blazered2035063blazered
blazoned2044313blazoned
bleacher15358883bleacher
bleaches153410673bleaches
blench133710453blench__
blenchers16356723blenchers
blended114710713blen_ded
blinded114810023blin_ded
blinked144010013blin_ked
blocked16449983bl_ocked
blotches1537433blotches
blucher143310223bl_ucher
blunged114310133blun_ged
blunted104210663blun_ted
blushed134411753bl_ushed
botched153611903b_otched
bounced123610553bounc_ed
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
bunches144116033b_unches
buncoed12378443b_uncoed
cached145419203_ca_ched
chanced154113213chanc_ed
cinched153910863_cinched
clacked164113603cla_cked
clanged114212653clan_ged
clanked143812253clan_ked
clashed133614013cla_shed
clencher15277973clencher
clenches152910953clenches
cliched153711023cl_iched
clincher15347663clincher
clinches153910363clinches
clutched16356033clutched
coached153313843coa_ched
cranches153114543cranches
craunched1764023craunched
crunched16328163crunched
danced105315253_danc_ed
drenched15247913drenched
fancied133310603_fancied
flacked173711583fla_cked
flancard1443373flancard
flanged123810843flan_ged
flanked153710643flan_ked
flashed144112183fla_shed
fleeched17345823fleeched
flenches163410533flenches
fletched17306693fletched
flincher16256583flincher
flinches16358953flinches
flitched17256293flitched
frenched17299433frenched
glaceed1136193gla_ceed
glance94312313glanc_e_
glancer103710073glanc_er
glances104113143glanc_es
glunches1436263glunches
hatched163414463_hatched
haunched1744813haunched
hunched163710493_hunched
inarched1486113inarched
inched124514483__inched
klatches17157133klatches
laced87132643_la_c_ed
laches116528343_la_ches
lacked135324653_la_cked
lanated8313203_lanated
lance75126723_lanc_e_
lancer84319973_lanc_er
lances84824103_lanc_es
lancet84223573_lanc_et
lanceted1137073_lanceted
landed84619243_lan_ded
larchen12479623_larchen
larches124416443_larches
lashed105625213_la_shed
latches123320123_latches
latchet123117903_latchet
lathed104718453_la_thed
laughed1235893_laughed
launcher1365563_launcher
launches1387903_launches
leached133715043_leached
leched123716003_l_eched
leeched13369503_leeched
letched133912053_letched
luncher123111413_luncher
lunches124115443_lunches
lurched13358033_lurched
lyncher15366553_lyncher
lynches15378873_lynches
manche133515103_manche_
manches143818623_manches
manchet143317773_manchet
marched153813403_marched
matched153513963_matched
munched153411073_munched
nuanced1036203nuanc_ed
parched154013693_parched
patched153514623_patched
paunched1645523paunched
peached154315883pea_ched
pinched153812453_pinched
placed114318003pla_c_ed
planch133711443planch__
planchets16236743planchets
planed94420913plan__ed
planished1566123planished
planked143512283plan_ked
planned103810153plan_ned
planted103516123plan_ted
plashed133712643pla_shed
pleached16338063pleached
plenches153110623plenches
poached154212403poa_ched
pranced123714043pranc_ed
punched153512173_punched
quenched2334103quenched
rancher123013633_rancher
ranches123620113_ranches
reached134619083rea_ched
rebranched1843673rebranched
relaunched1642683relaunched
roached133211833roa_ched
searched14209253searched
slacked143815453sla_cked
slanged94112853slan_ged
slanted83514743slan_ted
slashed114114853sla_shed
slatches131511523slatches
slouched14206743slouched
snatched14157633snatched
stancher13198813stancher
stanches132312793stanches
starched14199313starched
staunched1553473staunched
synched16277213_synched
thatched1735433thatched
tranced104414173tranc_ed
tranche123312223tranche_
tranches132915513tranches
trenched14289853trenched
unarched14128553unarched
unblenched1842563unblenched
unbranched1843533unbranched
unlatched1544213unlatched
valanced1475463valanc_ed
watched163012823_watched
wenched163910913_wenched
winched163110593_winched
wrenched17748133wrenched

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.406440125.6
2DLD Change Limit1461622546.87321266.1
3Display Results2542540.0932731.2
 (SQL Overall)1786912547.37224239.1
 
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.