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

137 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
feathered1618889(None) 
fathered151510431f_athered
featherbed19174661featherbed
heathered16149461heathered
leathered13148711leathered
weathered16168511weathered
blathered15168362blathered
feather133613502feather__
featherbeds20193572featherbeds
featheredge1972712featheredge
featherhead2153072featherhead
featherier1645802featherier
feathers143513242feather_s
feathery17368072feather_y
featured1237682feat_ured
festered122512112fest_ered
fettered12259492fe_ttered
flattered13188642flattered
furthered1644482furthered
gathered13149382_gathered
lathered121512332_lathered
neatherd12107192neather_d
regathered15124572regathered
slathered13148552slathered
tethered1238492te_thered
adhered1239233__adhered
battered113315073_battered
beavered1437503bea_vered
betattered1343143betattered
bettered113011843be_ttered
blatherer14176723blatherer
blattered12198583blattered
blethered15165433blethered
blithered15156123blithered
bothered142110393_bothered
brothered1546003brothered
catered103117783_cat_ered
centered112513523cent_ered
chattered15198003chattered
clattered12178423clattered
cratered1149693crat_ered
deathbed1543393death_bed
dewatered1444743dewat_ered
dithered13189293_dithered
entered82718883_ent_ered
faltered122811003f_altered
fathead1437863f_athe_ad
fatheaded1744273f_atheaded
father125116713f_ather__
fatherly1745073f_atherly
fathers133916503f_ather_s
fathomed1744733f_athomed
fattened12268283f_attened
feared106320433fea___red
feater95224053feat_er__
featheredged21102053featheredged
featheredges2072603featheredges
featherheads2252593featherheads
featheriest1745693featheriest
feathering17108793feathering
featherless1743913featherless
feature1039853feat_ure_
features11310333feat_ures
fendered13258673fe_ndered
fetterer11207813fe_tterer
fevered14339723fe__vered
filtered12259043filt_ered
flathead1535813flathe_ad
flattened13185303flattened
flatterer12187683flatterer
flittered13196253flittered
fluttered13185943fluttered
foregathered2051783foregathered
forgathered1951823forgathered
fostered122210453fost_ered
frittered13205163frittered
furtherer1543813furtherer
gatherer12147913_gatherer
gettered10258613ge_ttered
goatherd1335263goather_d
heather133914853heather__
heathers143914733heather_s
heathery17349083heather_y
ingathered1542963ingathered
kashered1636403_kashered
latherer111310453_latherer
leaguered1143223leaguered
leather103815783leather__
leathern11398913leather_n
leathers114215083leather_s
leathery14438973leather_y
lechered1437523le_chered
lettered92910783le_ttered
mattered112412913_mattered
meandered1346143meandered
meathead1436793meathe_ad
megathere1544733megathere_
megatheres1644853megatheres
metered103514013me_t_ered
mothered142310103_mothered
murthered1544483murthered
nattered92011633_nattered
neatened937043neat_ened
neatherds1395773neatherds
neutered937423neut_ered
pattered112714213_pattered
peltered112510453pelt_ered
pestered112814973pest_ered
petered103314973pe_t_ered
pothered142311043_pothered
realtered1037903realtered
reuttered1036073reuttered
scattered12197363scattered
shattered13178213shattered
slithered13136623slithered
smattered12186793smattered
smothered1545683smothered
spattered12187653spattered
swithered16135463swithered
tattered92011453_tattered
teetered9258303teet_ered
telphered1544223telphered
tentered96412103tent_ered
unfathered1743783unfathered
unweathered1852503unweathered
upgathered1742023upgathered
watered113014963_wat_ered
weather133513223weather__
weatherized2745173weatherized
weatherly1844403weatherly
weathermen1844503weathermen
weathers143412833weather_s
weltered12238443welt_ered
westered122511873west_ered
withered15169433_withered
wuthered15157433_wuthered
yattered12239543_yattered

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.420425454.8
2DLD Change Limit1486411377.08020994.5
3Display Results1371370.0632174.6
 (SQL Overall)1786911377.56323627.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.