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

134 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
aweather143426(None) 
weather133513221_weather
aether94213672a_e_ther
breather133610592breather
feather133613502_feather
heather133914852_heather
leather103815782_leather
pleather1356652pleather
sheather1458232sheather
swather134213602sw_ather
sweater103712722sweat_er
sweatier1147032sweatier
weathers143412832_weathers
wether123315392_we_ther
wreather14268602wreather
abater85518123a_bat_er
abetter958323abe_tter
adepter1036113adept_er
aethers103614943a_e_thers
alerter72111513alert_er
another10289153a_nother
anteater8311603anteat_er
anther93715063a__nther
attacher13125713attacher
averter102410553avert_er
awaiter1057443aw_aiter
awarder1135893aw_arder
bather115322513__bather
beater84729393_beat_er
blather125314203_blather
bleacher15358883bleacher
bleater94515303bleat_er
blether12459913ble_ther
breacher153011503breacher
breathe123711843breathe_
breathed14469643breathed
breathers14319103breathers
breathes134212903breathes
breathier1435383breathier
cheater124816963cheat_er
dewater112912423dewat_er
diether1147443die_ther
eater54639843__eat_er
either94517423__either
ether84518773__e_ther
father125116713__father
feater95224053_feat_er
feathers143513243_feathers
feathery17368073_feathery
gather104115853__gather
greater84416493great_er
heater94828303_heat_er
heathen133410893_heathen
heathers143914733_heathers
heathery17349083_heathery
heathier1438343_heathier
ingather1244783ingather
lather95124353__lather
leacher124014843_leacher
leathern11398913_leathern
leathers114215083_leathers
leathery14438973_leathery
loather103711003_loather
meatier93214613_meatier
neater64424313_neat_er
neatherd12107193_neatherd
neither1037573_neither
nether94014163_ne_ther
peacher144216073_peacher
peatier94017233_peatier
pleater93916333pleat_er
pleathers1446453pleathers
preacher153211373preacher
rather94319743__rather
reacher123718293_reacher
regather1236733regather
seater64534163_seat_er
sheathe1348993sheathe_
sheathed1547223sheathed
sheathers1557553sheathers
sheathes14610193sheathes
slather103816073_slather
swasher134011513sw_asher
swathe125514113sw_athe_
swathed144611933sw_athed
swathers144512083sw_athers
swathes134115513sw_athes
swatter104113323sw_atter
swearer10349953swea_rer
sweated113411543sweat_ed
sweaters113811063sweat_ers
sweeter103212003sweet_er
swelter103711173swelt_er
swither133710993sw_ither
teacher123714833_teacher
teether10349693_teether
tether93716103_te_ther
theater104014253theat_er
treater74219833treat_er
tweakier1533143tweakier
tweeter10288533tweet_er
upgather14152753upgather
washer124720393_w_asher
watcher153113403_w_atcher
water84733313_w_at_er
watter93221983_w_atter
weaker134015443_wea_ker
wealthier1543263_wealthier
weaner93816773_wea_ner
wearer94319403_wea_rer
wearier103613283_wearier
weathered16168513_weathered
weatherly1844403_weatherly
weaver123916613_wea_ver
weigher14136343_weigher
welcher15319393_welcher
welsher13377443_welsher
welter93417383_welt_er
wencher153811133_wencher
wester94222893_west_er
wethers135214693_we_thers
wetter93919443_we_tter
whether16346623_whether
whither163510253_whither
wither124321353_w_ither
wrathed14298523_wrathed
wrathier1435903_wrathier
wreathe13339053wreathe_
wreathed15257463wreathed
wreathen14256143wreathen
wreathers15257493wreathers
wreathes14299893wreathes
writher134010853_writher
wuther124511613_w_uther

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 Filter1786911461620.423422437.4
2DLD Change Limit1461621347.45319611.2
3Display Results1341340.0462913.0
 (SQL Overall)1786911347.92222556.3
 
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.