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

173 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
blanching1729709(None) 
blenching17276501blenching
branching17289261branching
baching156017752b_a_ching
balancing1435782balanc_ing
batching163712092b_atching
beaching164114142bea_ching
benching163411342b_enching
blacking174213602bla_cking
blanking154411932blan_king
bleaching17287092bleaching
blotching1734962blotching
brunching17316482brunching
bunching163410702b_unching
clenching17266302clenching
clinching17276122clinching
cranching17278732cranching
flenching18296702flenching
flinching18245832flinching
glancing1247062glanc_ing
glunching16174082glunching
lancing103314122_lanc_ing
latching143712022_latching
launching1544782_launching
lunching143110002_lunching
lynching17336082_lynching
ranching141712042_ranching
stanching1538082stanching
aching126521973__a_ching
arching136216693__arching
avalanching2051583avalanching
backing165523443b_a_cking
banding114921413b_an_ding
bandying15218073b_andying
banging114019863b_an_ging
baning95127833b_an__ing
banishing1537143b_anishing
banking144621353b_an_king
banning103818233b_an_ning
bantling112612003b_antling
bashing135422583b_a_shing
bathing134816243b_a_thing
beaning103820683bean__ing
belching16349153b_elching
birching16328463b_irching
bitching163610623b_itching
blabbing12266723bla_bbing
blackings18316763bla_ckings
blading113615363bla__ding
blagging13319163bla_gging
blaming123515693bla__ming
blanch133410853blanch___
blanched16308603blanch_ed
blancher15338633blanch_er
blanchers16307433blanchers
blanches153311603blanch_es
blancmange175863blancmange
blandishing1852903blandishing
blanketing1743323blanketing
blaring104317113bla__ring
blarneying1641943blarneying
blasting114013433bla_sting
blatting114111653bla_tting
blawing134012753bla__wing
blazing193612393bla__zing
blazoning2144033blazoning
blending12249963blen_ding
blinding123210163blin_ding
blinking153510623blin_king
blocking174510573bl_ocking
blunging12328413blun_ging
blunting11319843blun_ting
blushing14339333bl_ushing
botching16359703b_otching
bouncing13318773bounc_ing
bracing123817613bra_c_ing
branchia15217713branchi_a
branchiae16186313branchiae
branchial16215963branchial
branchier1637133branchier
branchline1744123branchline
branding122513683bran_ding
brandling1348253brandling
brandying1654883brandying
branning112911093bran_ning
breaching17269403breaching
breeching17236473breeching
broaching17287663broaching
buncoing13337813b_uncoing
caching156317503_ca_ching
catching163712773_catching
chancing162810283chanc_ing
cinching163310223_cinching
clacking173313493cla_cking
clanging124012123clan_ging
clanking154313063clan_king
clashing143812193cla_shing
clutching17154823clutching
coaching164011963coa_ching
craunching1843313craunching
crunching17297003crunching
dancing113611563_danc_ing
drenching16256033drenching
fancying1735353_fancying
flacking184311793fla_cking
flanging132710583flan_ging
flanking164211083flan_king
flashing153711553fla_shing
fleeching18305013fleeching
fletching18256143fletching
flitching18265343flitching
frenching18267753frenching
glaceing1236533gla_ceing
hatching173312213_hatching
hunching17309113_hunching
inarching1546343inarching
inching134414323__inching
lacing94626233_la_c_ing
lacking143821543_la_cking
landing92819323_lan_ding
lashing114422893_la_shing
lathing114315693_la_thing
laughing1335933_laughing
leaching143012833_leaching
leching134613653_l_eching
leeching14318373_leeching
letching143810263_letching
lurching14277333_lurching
lynchings18233503_lynchings
marching164312193_marching
matching163512393_matching
munching16299973_munching
parching164313053_parching
patching163212753_patching
peaching163613643pea_ching
pinching163711053_pinching
placing123815283pla_c_ing
planing103418253plan__ing
planishing1645323planishing
planking153513013plan_king
planning113610223plan_ning
planting113515383plan_ting
plashing143311063pla_shing
plaything1843853plaything
pleaching17257083pleaching
poaching163510833poa_ching
prancing132612163pranc_ing
punching163310123_punching
quenching2443923quenching
reaching143317203rea_ching
rebranching1943383rebranching
relaunching1742243relaunching
roaching143210433roa_ching
searching1538343searching
slacking153914133sla_cking
slanging103413433slan_ging
slanting94115093slan_ting
slashing123713413sla_shing
slouching15195723slouching
snatching1536363snatching
starching1538593starching
staunching1643213staunching
synching17227713_synching
teaching143612603tea_ching
thatching1835143thatching
trancing112812023tranc_ing
trenching15227653trenching
unlatching1643153unlatching
valancing1544743valanc_ing
watching173011173_watching
wenching17328863_wenching
winching17359903_winching
wrenching18276273wrenching

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 Filter1786911486410.406440125.6
2DLD Change Limit1486411737.42020032.5
3Display Results1731730.0802162.5
 (SQL Overall)1786911737.90622601.9
 
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.