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

101 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
feathering1710879(None) 
fathering161010091f_athering
featherings18105371featherings
leathering1488681leathering
weathering1798351weathering
blathering16107582blathering
featherier1645802featherier
featuring1337322feat_uring
festering132413172fest_ering
fettering132310512fe_ttering
flattering1498742flattering
furthering1744352furthering
gathering1499462_gathering
lathering13912252_lathering
regathering1645202regathering
slathering14108282slathering
tethering1339132te_thering
weatherings1895262weatherings
adhering1338883__adhering
atheling1249203__atheling
battering122715143_battering
beavering1538703bea_vering
betattering1444143betattering
bettering122212753be_ttering
blattering13108713blattering
blethering16115933blethering
blithering16116123blithering
bothering152210203_bothering
brothering1646033brothering
catering112019903_cat_ering
centering122915143cent_ering
chattering16108643chattering
clattering13109233clattering
cratering12312653crat_ering
dewatering1545773dewat_ering
dithering1499853_dithering
entering91920053_ent_ering
faltering132211113f_altering
fathoming1844693f_athoming
fattening13287833f_attening
fearing113520033fea___ring
feather133613503feather___
featherbed19174663featherbed
feathered16188893feather_ed
featheredge1972713featheredge
featheredging2261483featheredging
featheriest1745683featheriest
feathers143513243feather__s
feathery17368073feather__y
fevering152510083fe__vering
filtering13199723filt_ering
flattening14115103flattening
flittering1486503flittering
fluttering14106293fluttering
foregathering2151953foregathering
forgathering2052193forgathering
fostering132411263fost_ering
frittering14105623frittering
gatherings15105293_gatherings
gettering112310033ge_ttering
ingathering16103013ingathering
kashering1736253_kashering
leaguering1243813leaguering
leathern11398913leather_n_
lechering1538443le_chering
lettering102112073le_ttering
mattering122314053_mattering
meandering1446983meandering
metering112915633me_t_ering
mothering152110183_mothering
murthering1644473murthering
nattering102212213_nattering
neatening1038353neat_ening
neutering1038963neut_ering
pattering122314423_pattering
peltering122011673pelt_ering
pestering122315663pest_ering
petering112516813pe_t_ering
pothering151911283_pothering
realtering1139473realtering
reuttering1137573reuttering
scattering1398013scattering
shattering1498283shattering
slithering1496893slithering
smattering1397583smattering
smothering1646013smothering
spattering13107793spattering
swithering17105213swithering
tattering102212323_tattering
teetering10239893teet_ering
telphering1644203telphering
tentering102313203tent_ering
upgathering1842203upgathering
watering122316313_wat_ering
weatherize2545843weatherize
weatherizing2854353weatherizing
weltering13219493welt_ering
westering132112643west_ering
withering16108813_withering
wuthering1697803_wuthering
yattering132410443_yattering

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 Filter1786911406030.436409841.7
2DLD Change Limit1406031016.11023011.9
3Display Results1011010.0631603.2
 (SQL Overall)1786911016.60927037.5
 
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.