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

413 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
blanch13341085(None) 
blench133710451blench
branch134014771branch
planch133711441planch
bach116131392b_a_ch
balance11510262balance
banco94019392b_anco
batch124620102b_atch
beach124623892bea_ch
bench125619502b_ench
black134719072bla_ck
blah98625062bla__h
blanched16308602blanched
blancher15338632blancher
blanches153311602blanches
bland85320452blan_d
blank115418552blan_k
blanks124112892blanks
bleach133611402bleach
blotch13197142blotch
brach126123302bra_ch
branchy17357912branchy
brunch13329352brunch
bunch125118602b_unch
clach124617822cla_ch
clench133910052clench
clinch133910352clinch
cranch133613532cranch
flench144010812flench
flinch144010102flinch
glance94312312glance
glunch1255352glunch
klatch15445932klatch
laich105920712_laich
lance75126722_lance
larch105919792_larch
latch104620462_latch
launch11368062_launch
lunch104917242_lunch
lynch13468982_lynch
planche14299752planche
plench134010812plench
ranch105019792_ranch
slatch114510532slatch
stanch113812372stanch
alack114820063ala_ck
alan46844083alan__
aland65526413alan_d
alands75418373alands
alane56135613alan_e
alang66023513alan_g
alanin6317273alanin
alans55636173alan_s
alant55742293alan_t
alants67722023alants
alanyl955483alanyl
anarch11310393anarch
ancho104515303__ancho
ankh111114413__ankh
arch98628443__arch
bacca111012183b_acca
back125535763b_a_ck
bah87755353b_a__h
baith108023133b_aith
balanced1356513balanced
balancer1246603balancer
balances1279973balances
ban58366833b_an__
banal75925993b_anal
bancos104713893b_ancos
band76740903b_an_d
banda85223103b_anda
bands85233423b_ands
bandy114824183b_andy
bane65250423b_an_e
baned85436353b_aned
banes74945583b_anes
bang74836993b_an_g
bangs85627773b_angs
bani65334953b_an_i
banish111416043b_anish
banjo143812443b_anjo
bank105835743b_an_k
banks115527903b_anks
banns75321233b_anns
bans66555133b_an_s
banty106624003b_anty
barca91319433b_arca
bash915240163b_a_sh
bath95940083b_a_th
beachy164011253bea_chy
bean66443863bean__
beaned95621473beaned
beanie83618593beanie
beano75421553bean_o
beanos85516513beanos
beans75734693bean_s
beech124315503b_eech
belch124415503b_elch
bhang115512923bhan_g
bhangs12449663bhangs
birch124914023b_irch
bitch125017763b_itch
blab86629133bla__b
blabby1234813blabby
blabs95619633bla_bs
blacks144914953blacks
blade85923333bla_de
bladed104717763bladed
blader93618583blader
blades95221253blades
blae66134643bla__e
blaff135216483bla_ff
blaffs14426623blaffs
blahs105616513bla_hs
blain75421793bla_in
blains84516373blains
blam86131703bla__m
blame95625493bla_me
blamed116017953blamed
blamer104417143blamer
blames105121863blames
blams95023853bla_ms
blanchers16307433blanchers
blanching17297093blanching
blander103715163blander
blandish1497003blandish
blandly1336043blandly
blanked144011223blanked
blanker134612023blanker
blanket134313093blanket
blankly1634263blankly
blare75826233bla_re
blared95018243blared
blares85021633blares
blarney12174763blarney
blase75524233bla_se
blast76532573bla_st
blasts85116773blasts
blasty115611053blasty
blat66550953bla__t
blatancy1543573blatancy
blate75933783bla_te
blats75132503bla_ts
blaw97026723bla__w
blawed124713893blawed
blawn106813703bla_wn
blaws105620463bla_ws
blaze165520833bla_ze
blazed184314713blazed
blazer174414023blazer
blazes174817353blazes
blazon1736763blazon
blenched16358053blenched
blencher15308393blencher
blenches153310763blenches
blend85317453blen_d
blende95413443blende
blends96012883blends
blenny1156203blenny
blent76230953blen_t
blin67228173blin__
blind86319323blin_d
blinds95111613blinds
blini75519273blin_i
blinis85313683blinis
blink115720143blin_k
blinks124613573blinks
blintz1788843blintz
bloc85023273bl_oc_
block134917843bl_ock
blocs95219653bl_ocs
blond85618373blon_d
blonde94813293blonde
blonds95213343blonds
blotchy17293973blotchy
bluish1159243bluish
blunge94311483blunge
blunt75525023blun_t
blunts84512893blunts
blush105115313bl_ush
bonaci10310963bonaci
borsch1336133borsch
botch126717453b_otch
bounce104014833bounce
bouncy13409073bouncy
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
bunchy16437463b_unchy
bunco94616083b_unco
butch125416543b_utch
bwana10310243bwan_a
bwanas1157443bwanas
bycatch1942063bycatch
cancha134411613_cancha
catch125120373_catch
chance134617093chance
chancy164010863chancy
chinch163911223chinch
cinch124516243_cinch
clachs133511323cla_chs
clack134720173cla_ck
clan65633923clan__
clang86019313clan_g
clangs95113613clangs
clank114719523clan_k
clanks124615183clanks
clanky15469073clanky
clans75031013clan_s
clash106219033cla_sh
claucht1445583claucht
clutch13367753clutch
coach125919453coa_ch
conch124620073_conch
cratch134110793cratch
craunch1464443craunch
crunch13349503crunch
dance85223133_dance
drench12369593drench
dunch115316263_dunch
each95530583_ea_ch
elan46734243elan__
eland65820393elan_d
elands74914773elands
elans55527753elan_s
elenchi1244713elenchi
eparch13258423eparch
exarch18196173exarch
fancy134615483_fancy
fiance11310743fiance
finch135416973_finch
flack144519413fla_ck
flan76134183flan__
flanes94522423flanes
flange103411973flange
flank124618093flan_k
flanks133913403flanks
flans85327973flan_s
flash115716213fla_sh
fleech14367343fleech
fletch14388193fletch
flitch14928173flitch
flysch1732893flysch
franc104615413franc_
francs114112193francs
french143511213french
glace87420153gla_ce
glanced11439233glanced
glancer103710073glancer
glances104113143glances
gland75217713glan_d
glands85314403glands
glans65125833glan_s
glitch12286353glitch
grinch1238473grinch
hance105424153_hance
hatch135719593_hatch
haunch14377343haunch
hunch136416213_hunch
inarch1139163inarch
inch95420823__inch
kench145513923_kench
klatsch1651683klatsch
lac510155823_la_c_
lace66848473_la_ce
lack105837683_la_ck
lacs66942483_la_cs
lacy95829633_la_cy
laic65931563_laic_
laichs115110893_laichs
laics76419253_laics
laigh95515923_laigh
laith85722103_laith
lakh114919953_la_kh
lanai5319573_lanai
lanced93717723_lanced
lancer84319973_lancer
lances84824103_lances
lancet84223573_lancet
land56337303_lan_d
lands65426903_lands
lane45153323_lan_e
lanes54946793_lanes
lang56637373_lan_g
lank84734443_lan_k
lanky125517483_lanky
lash76539653_la_sh
lath76640383_la_th
laugh94414373_laugh
launce8469183_launce
leach105422523_leach
lech96825443_l_ech
leech104913213_leech
letch105215803_letch
lich96230843_l_ich
llano5910603llan_o
llanos6108333llanos
loach105116363_loach
loch95527133_l_och
lurch104814633_lurch
lych126015763_l_ych
mach116134473_ma_ch
manche133515103_manche
march125622893_march
match125621103_match
munch124917103_munch
nance74721843_nance
nancy105214923_nancy
natch105018223_natch
nuance859043nuance
orach105219233ora_ch
painch133511323painch
parch125123003_parch
patch125221223_patch
paunch13369853paunch
peach125422493pea_ch
pinch125619303_pinch
place94824613pla_ce
plack135017843pla_ck
plaice10311553plaice
plan65833943plan__
planar84212713planar
planches153111863planches
planchet152511963planchet
plane74929143plan_e
planed94420913planed
planer84122653planer
planes85028083planes
planet84228353planet
planish12412053planish
plank115221143plan_k
planks124116753planks
plans75731273plan_s
plant75437113plan_t
plants84921803plants
plash104616563pla_sh
pleach134211243pleach
pliancy1435593pliancy
plinth11310453plinth
poach124917863poa_ch
prance104318573prance
punch125118423_punch
quaich2047693quaich
quench2036633quench
rance75028513_rance
rancho114310853_rancho
ratch104221363_ratch
raunch11358433raunch
reach105123883rea_ch
rebranch1545793rebranch
relaunch1352803relaunch
roach105717003roa_ch
sangh95517453_sangh
sauch104918773_sauch
seance83716683seance
search113312423search
slack115021763sla_ck
slang66324023slan_g
slangs75615343slangs
slangy105411393slangy
slank95822773slan_k
slant55238703slan_t
slants64819083slants
slanty95114843slanty
slash84719683sla_sh
slouch11438523slouch
snatch114310603snatch
stance84316913stance
starch113013203starch
staunch1244273staunch
stench114111163stench
swatch14549283swatch
synch135011793_synch
tach96132753_ta_ch
teach105221123tea_ch
tench105620003_tench
thatch1435603thatch
trance84718763trance
tranche123312223tranche
trench114211613trench
ulan46527393ulan__
ulans54921303ulan_s
unlatch1245053unlatch
usance858013usance
valance1269253valance
watch135617063_watch
wench136214783_wench
winch135016663_winch
wrench14439353wrench

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 Limit1127164136.33017806.6
3Display Results4134130.1402950.0
 (SQL Overall)1786914136.61027033.4
 
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.