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

105 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
fleeching1830501(None) 
fleecing14347571fleec_ing
flenching18296701flenching
fletching18256141fletching
leeching14318371_leeching
bleaching17287092bleaching
blenching17276502blenching
breeching17236472breeching
clenching17266302clenching
fetching17298412f_etching
flecking18408232fl_ecking
fleeing113511292flee__ing
fleering123811282flee_ring
fleeting122910322flee_ting
fleshing15339302fl_eshing
fletchings19282862fletchings
flinching18245832flinching
flitching18265342flitching
frenching18267752frenching
leaching143012832_leaching
leching134613652_l_eching
letching143810262_letching
pleaching17257082pleaching
beaching164114143_beaching
belching16349153_belching
benching163411343_benching
beseeching1843363beseeching
blanching17297093blanching
bleeding12359053blee_ding
bleeping13377933blee_ping
blotching1734963blotching
breaching17269403breaching
breechings18273723breechings
cleeking15267813clee_king
clinching17276123clinching
clutching17154823clutching
creeshing1536243creeshing
drenching16256033drenching
eching126315563___eching
electing112113783el_ecting
etching134511843__etching
feeding123515073f_ee_ding
feeing104416503f_ee__ing
feeling113617073f_ee_ling
feezing204610163f_ee_zing
fencing132411133f_enc_ing
filching1736113f_ilching
flacking184311793fl_acking
flashing153711553fl_ashing
fledging14276523fl_edging
fledgling1552473fledgling
fleech14367343fleech___
fleeched17345823fleech_ed
fleeches16287083fleech_es
fleecier1334763fleec_ier
fleecily1644013fleec_ily
fleishig1542893fleishi_g
flemishing1943493flemishing
flensing1246973fl_ensing
fleshings16335383fl_eshings
flexing18358993fl_e_xing
fleying14329873fl_e_ying
flicking184110043fl_icking
floccing16306033fl_occing
flocking183410873fl_ocking
flushing15288833fl_ushing
freeing113713913free__ing
freezing21308323free_zing
frescoing1544683frescoing
freshing152611023f_reshing
gleeking14316493glee_king
gleeting10279173glee_ting
glunching16174083glunching
kvetching2242903kvetching
latching143712023_latching
leashing123310313_leashing
leering83417643_lee_ring
lunching143110003_lunching
lurching14277333_lurching
lynching17336083_lynching
peaching163613643_peaching
peching154513903__peching
perching163711633_perching
preaching172811163preaching
quenching2443923quenching
reaching143317203_reaching
reechoing1545293_reechoing
retching143412173_retching
screeching1843643screeching
seething1239023_seething
selecting12310533selecting
sketching1935083sketching
sleeking133410963slee_king
sleeping113812053slee_ping
sleeting93114163slee_ting
sleeving12359283slee_ving
sleighing1434213sleighing
sleuthing1334203sleuthing
slouching15195723slouching
teaching143612603_teaching
teething1237163_teething
trenching15227653trenching
welching17287363_welching
wenching17328863_wenching
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.423422437.4
2DLD Change Limit1486411056.68622231.7
3Display Results1051050.0462282.6
 (SQL Overall)1786911057.15524974.3
 
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.