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
blathered15168352blathered
feather133613502feather__
featherbeds20193572featherbeds
featheredge1972712featheredge
featherhead2153062featherhead
featherier1645802featherier
feathers143513242feather_s
feathery17368072feather_y
featured1237682feat_ured
festered122512102fest_ered
fettered12259492fe_ttered
flattered13188622flattered
furthered1644472furthered
gathered13149372_gathered
lathered121512322_lathered
neatherd12107192neather_d
regathered15124572regathered
slathered13148542slathered
tethered1238492te_thered
adhered1239233__adhered
battered113315053_battered
beavered1437503bea_vered
betattered1343143betattered
bettered113011833be_ttered
blatherer14176713blatherer
blattered12198563blattered
blethered15165433blethered
blithered15156123blithered
bothered142110393_bothered
brothered1546003brothered
catered103117773_cat_ered
centered112513523cent_ered
chattered15197993chattered
clattered12178403clattered
cratered1149683crat_ered
deathbed1543393death_bed
dewatered1444743dewat_ered
dithered13189293_dithered
entered82718883_ent_ered
faltered122810983f_altered
fathead1437863f_athe_ad
fatheaded1744273f_atheaded
father125116713f_ather__
fatherly1745073f_atherly
fathers133916503f_ather_s
fathomed1744733f_athomed
fattened12268283f_attened
feared106320433fea___red
feater95224053feat_er__
featheredged21102053featheredged
featheredges2072603featheredges
featherheads2252593featherheads
featheriest1745683featheriest
feathering17108793feathering
featherless1743913featherless
feature1039853feat_ure_
features11310333feat_ures
fendered13258673fe_ndered
fetterer11207813fe_tterer
fevered14339723fe__vered
filtered12259043filt_ered
flathead1535803flathe_ad
flattened13185303flattened
flatterer12187673flatterer
flittered13196253flittered
fluttered13185943fluttered
foregathered2051783foregathered
forgathered1951823forgathered
fostered122210453fost_ered
frittered13205163frittered
furtherer1543813furtherer
gatherer12147903_gatherer
gettered10258613ge_ttered
goatherd1335263goather_d
heather133914853heather__
heathers143914733heather_s
heathery17349083heather_y
ingathered1542963ingathered
kashered1636403_kashered
latherer111310443_latherer
leaguered1143223leaguered
leather103815783leather__
leathern11398913leather_n
leathers114215083leather_s
leathery14438973leather_y
lechered1437523le_chered
lettered92910783le_ttered
mattered112412903_mattered
meandered1346143meandered
meathead1436793meathe_ad
megathere1544733megathere_
megatheres1644853megatheres
metered103514013me_t_ered
mothered142310103_mothered
murthered1544473murthered
nattered92011623_nattered
neatened937043neat_ened
neatherds1395773neatherds
neutered937423neut_ered
pattered112714203_pattered
peltered112510443pelt_ered
pestered112814953pest_ered
petered103314963pe_t_ered
pothered142311043_pothered
realtered1037893realtered
reuttered1036073reuttered
scattered12197353scattered
shattered13178203shattered
slithered13136623slithered
smattered12186783smattered
smothered1545683smothered
spattered12187643spattered
swithered16135463swithered
tattered92011443_tattered
teetered9258303teet_ered
telphered1544213telphered
tentered96412103tent_ered
unfathered1743783unfathered
unweathered1852503unweathered
upgathered1742023upgathered
watered113014953_wat_ered
weather133513223weather__
weatherized2745173weatherized
weatherly1844403weatherly
weathermen1844503weathermen
weathers143412833weather_s
weltered12238433welt_ered
westered122511863west_ered
withered15169433_withered
wuthered15157433_wuthered
yattered12239533_yattered

Search took 9 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.186960704.3
2DLD Change Limit1486411378.28317945.3
3Display Results1371370.0462978.3
 (SQL Overall)1786911378.51520985.4
 
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.