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

122 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
blenching1727650(None) 
benching163411341b_enching
blanching17297091blanching
bleaching17287091bleaching
clenching17266301clenching
flenching18296701flenching
beaching164114142b_eaching
belching16349152b_elching
blending12249962blen_ding
blotching1734962blotching
branching17289262branching
breaching17269402breaching
breeching17236472breeching
brunching17316482brunching
bunching163410702b_unching
clinching17276122clinching
drenching16256032drenching
fleeching18305012fleeching
fletching18256142fletching
flinching18245832flinching
frenching18267752frenching
glunching16174082glunching
leaching143012832_leaching
leching134613652_le_ching
leeching14318372_leeching
letching143810262_letching
lunching143110002_lunching
lynching17336082_lynching
pleaching17257082pleaching
quenching2443922quenching
trenching15227652trenching
wenching17328862_wenching
wrenching18276272wrenching
baching156017753b__aching
balancing1435783balanc_ing
batching163712093b_atching
becking164416073b_e_cking
bedrenching2052273bedrenching
benaming1339693b_enaming
bending114420893b_en_ding
berthing14209593b_erthing
beseeching1843363beseeching
birching16328463b_irching
bitching163610623b_itching
blacking174213603bl_acking
blanking154411933blan_king
blearing113111943ble_aring
bleating113514503ble_ating
blebbing12265673ble_bbing
bleeding12359053ble_eding
bleeping13377933ble_eping
blemishing1843513blemishing
blench133710453blench___
blenched16358053blench_ed
blencher15308393blench_er
blenchers16356723blenchers
blenches153310763blench_es
blessing1137593ble_ssing
blinding123210163blin_ding
blinking153510623blin_king
blocking174510573bl_ocking
blunging12328413blun_ging
blunting11319843blun_ting
blushing14339333bl_ushing
botching16359703b_otching
bouncing13318773bounc_ing
breathing15218373breathing
breechings18273723breechings
broaching17287663broaching
buncoing13337813b_uncoing
cinching163310223_cinching
clutching17154823clutching
cranching17278733cranching
crunching17297003crunching
eching126315563__e_ching
electing112113783ele_cting
elenchi1244713elenchi__
elenchic1544223elenchi_c
etching134511843__etching
fencing132411133_fenc_ing
fetching17298413_fetching
flecking18408233fle_cking
fleecing14347573fleec_ing
flensing1246973flen_sing
fleshing15339303fle_shing
fletchings19282863fletchings
flitching18265343flitching
glancing1247063glanc_ing
hunching17309113_hunching
inching134414323__inching
kvetching2242903kvetching
lancing103314123_lanc_ing
latching143712023_latching
launching1544783launching
leashing123310313_leashing
lending94118533_len_ding
leniting9312353_leniting
lensing84015103_len_sing
lurching14277333_lurching
lynchings18233503_lynchings
munching16299973_munching
peaching163613643_peaching
peching154513903_pe_ching
perching163711633_perching
pinching163711053_pinching
plenishing1644693plenishing
preaching172811163preaching
punching163310123_punching
ranching141712043_ranching
reaching143317203_reaching
retching143412173_retching
silencing1245053silenc_ing
sketching1935083sketching
sleighing1434213sleighing
sleuthing1334203sleuthing
slouching15195723slouching
stanching1538083stanching
synching17227713_synching
teaching143612603_teaching
unclenching1952133unclenching
welching17287363_welching
winching17359903_winching

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.423422437.4
2DLD Change Limit1486411226.83021763.0
3Display Results1221220.0602033.3
 (SQL Overall)1786911227.31324434.7
 
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.