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

130 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
weathered1616851(None) 
feathered16188891feathered
heathered16149461heathered
leathered13148711leathered
blathered15168352blathered
fathered151510432_fathered
featherbed19174662featherbed
gathered13149372_gathered
lathered121512322_lathered
neatherd12107192neather_d
regathered15124572regathered
slathered13148542slathered
tethered1238492te_thered
unweathered1852502unweathered
watered113014952w_at_ered
weather133513222weather__
weatherized2745172weatherized
weatherly1844402weatherly
weathermen1844502weathermen
weathers143412832weather_s
weltered12238432welt_ered
westered122511872west_ered
withered15169432w_ithered
wuthered15157432w_uthered
adhered1239233__adhered
aweather1434263aweather__
battered113315053_battered
beavered1437503bea_vered
betattered1343143betattered
bettered113011843be_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
feather133613503feather__
featherbeds20193573featherbeds
featheredge1972713featheredge
featherhead2153063featherhead
featherier1645803featherier
feathers143513243feather_s
feathery17368073feather_y
featured1237683feat_ured
festered122512113fest_ered
fettered12259493fe_ttered
flattered13188623flattered
furthered1644473furthered
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
peltered112510453pelt_ered
pestered112814973pest_ered
petered103314973pe_t_ered
pothered142311043_pothered
realtered1037893realtered
reuttered1036073reuttered
scattered12197353scattered
shattered13178203shattered
slithered13136623slithered
smattered12186783smattered
smothered1545683smothered
spattered12187643spattered
sweltered1344453swelt_ered
swithered16135463swithered
tattered92011443_tattered
teetered9258303teet_ered
telphered1544223telphered
tentered96412103tent_ered
unfathered1743783unfathered
upgathered1742023upgathered
wafered14288433w_a_fered
wagered12299333w_a_gered
waitered1238753w_aitered
wandered132110793w_andered
waterbed1436443w_at_erbed
waterer103314073w_at_erer
wavered142910433w_a_vered
weakened1634823wea_kened
weakhearted2252193weakhearted
weaseled12175153wea_seled
weathering1798353weathering
weatherize2545843weatherize
weatherizes2645943weatherizes
weatherman1854243weatherman
wether123315393we_ther__
wethers135214693we_ther_s
wintered122111573wint_ered
witherer14187953w_itherer
witherod15156153w_itherod
wrathed14298523wrath__ed
wreathed15257463wreath__ed
wreather14268603wreather__
wreathers15257493wreather_s
yattered12239533_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.423422437.4
2DLD Change Limit1486411307.29620372.9
3Display Results1301300.0462826.1
 (SQL Overall)1786911307.76523012.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.