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

168 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
lechering153844(None) 
blethering16115932blethering
lackering1639372lackering
lathering13912252lathering
leathering1488682leathering
lecheries1449072lecheries
leching134613652lech__ing
lecturing1237302lecturing
leering83417642le__ering
lettering102112072lettering
levering122212502le_vering
lichening1545672lichening
ochering14219392_ochering
rechewing1836492rechewing
tethering1339132tethering
tochering1537152tochering
adhering1338883_adhering
anchoring1548323anchoring
beavering1538703beavering
becharming2044303becharming
bettering122212753bettering
bickering1837663bickering
blathering16107583blathering
blithering16116123blithering
bothering152210203bothering
butchering1844503butchering
cacheting1737153cacheting
centering122915143centering
cering94522533__c_ering
charing133721323__charing
checkering2244403checkering
cheering143612703__cheering
chefing16359033__chefing
chewing163911143__chewing
choring133617663__choring
ciphering17217703ciphering
cockering1839693cockering
cohering142413833_cohering
coshering15510023coshering
cyphering20175243cyphering
dackering1737383dackering
decerning1337293dec_erning
deciphering2053223deciphering
declaring1339573declaring
decreeing1335523decreeing
dickering1737463dickering
dithering1499853dithering
eching126315563_ech__ing
echoing1358613_ech_oing
entering91920053_entering
eschewing1893503eschewing
euchring1436613euch_ring
fathering161010093fathering
feathering17108793feathering
festering132413173festering
fettering132310513fettering
fevering152510083fe_vering
fleering123811283fle__ering
flichtering2042683flichtering
flickering2044093flickering
gathering1499463gathering
gendering12249753gendering
gettering112310033gettering
hachuring1845123hachuring
hectoring1538303hectoring
inhering12913713_inhering
jeering153513043je__ering
kashering1736253kashering
koshering1735363koshering
laagering1136833laagering
lacewing1435843lac_ewing
lackeying1934923lackeying
lacquering2243603lacquering
laddering1237593laddering
lagering102212313l_agering
lappering14258843lappering
laveering1336813laveering
lawyering1655213lawyering
layering122310353l_ayering
leaching143012833leach__ing
leadening1176733leadening
leaguering1243813leaguering
leavening1365973leavening
lecher113415853lecher___
lechered1437523lecher_ed
lecherous1445033lecherous
lechers123313963lecher__s
lechery15257643lecher__y
lectern937033lecter_n_
lecterns1035943lecter_ns
leeching14318373leech__ing
leistering1147983leistering
lessening1045333lessening
letching143810263letch__ing
letterings11226003letterings
leveeing12265963le_veeing
leveling122910433le_veling
lichenin1345053lichenin_
lichenins1444843lichenins
lichting14268513lich_ting
lightering15246113lightering
limbering1488793limbering
lingering11310513lingering
lippering14217883lippering
littering102411983littering
livering122012383l_ivering
loitering1039683loitering
loppering14237283loppering
lowering122210913l_owering
lumbering14117933lumbering
lustering102711203lustering
metering112915633me_tering
mothering152110183mothering
neutering1038963neutering
nickering1636573nickering
ochring13156673_och_ring
peching154513903pech__ing
peering103520353pe__ering
peltering122011673peltering
peppering1337083peppering
pestering122315663pestering
petering112516813pe_tering
pothering151911283pothering
puckering1835883puckering
racheting1537793racheting
receding122713763rec_eding
recharging1745293recharging
recharting1637213recharting
rechecking2244463rechecking
recovering1647373recovering
recurring1237953recurring
rehearing132211763re_hearing
rehiring122911883re_hiring
rendering112213183rendering
revering122918073re_vering
richening1546223richening
scheming1636633_scheming
seceding12288563sec_eding
secerning1246203sec_erning
secreting1279823secreting
sectoring1239583sectoring
securing11310413sec_uring
severing122013853se_vering
sewering122411093se_wering
slathering14108283slathering
slithering1496893slithering
sphering142811943_sphering
suckering1638103suckering
syphering18175733syphering
teddering12256303teddering
teetering10239893teetering
telfering1336253telfering
telphering1644203telphering
tempering1438733tempering
tendering112210813tendering
tentering102313203tentering
tuckering1635693tuckering
ulcering1139333ulc_ering
ushering1258923_ushering
vectoring1537413vectoring
veering113213683ve__ering
veneering1337663veneering
vouchering1943653vouchering
weathering1798353weathering
weltering13219493weltering
westering132112643westering
withering16108813withering
wuthering1697803wuthering

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.436409841.7
2DLD Change Limit1486411687.42320024.4
3Display Results1681680.0931806.5
 (SQL Overall)1786911687.95222471.2
 
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.