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

455 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
weathers14341283(None) 
feathers143513241feathers
heathers143914731heathers
leathers114215081leathers
weather133513221weather_
wethers135214691we_thers
wreathers15257481wreathers
aethers103614942ae_thers
aweather1434262aweather_
bathers124720362_bathers
beaters94925032beat_ers
blathers134713792blathers
breathers14319092breathers
eaters65535942_eat_ers
ethers94518412_e_thers
fathers133916502_fathers
feather133613502feather_
feathery17368072feathery
gathers114315062_gathers
heaters104225212heat_ers
heathens143210152heathens
heather133914852heather_
heathery17349082heathery
lathers104321882_lathers
leachers133712812leachers
leather103815782leather_
leathern11398912leathern
leathery14438972leathery
loathers113310432loathers
neatherd12107192neatherd
neatherds1395772neatherds
peachers153213842peachers
pleathers1446452pleathers
reachers133515722reachers
regathers1336332regathers
seaters74028932seat_ers
sheathers1557542sheathers
slathers113914772slathers
swathers144512072swathers
sweaters113811052sweat_ers
teachers133212392teachers
teethers11328712teethers
tethers103815312te_thers
washers134517522w_ashers
watchers163511792w_atchers
waters95030622w_at_ers
weaners104613832wea_ners
wearers104615902wea_rers
weathered16168512weathered
weatherly1844402weatherly
weavers133714462wea_vers
weighers15135672weighers
welchers16338052welchers
welshers14246812welshers
welters103516062welt_ers
wenchers16319212wenchers
westers105221962west_ers
wether123315392we_ther_
wetters103817752we_tters
withers134417752w_ithers
wreather14268602wreather_
wreathes14299892wreathe_s
writhers14398982writhers
wuthers133711522w_uthers
abaters95115193abat_ers
aether94213673ae_ther_
anthers103715203_anthers
bashers124820833_bashers
batchers153613273_batchers
bather115322513_bather_
bathes116524833_bathe_s
batters94626013_batters
beaches144120653beache_s
beaders104120183bea_ders
beakers134216873bea_kers
bearers94619593bea_rers
beater84729393beat_er_
beatless103311593beatless
beavers124417323bea_vers
beetlers1037393beetlers
belchers153510023belchers
belters93819413belt_ers
benchers153611013benchers
betatters1134963betatters
bethels1238533be_thels
betters94422093be_tters
blather125314203blather_
blatters104414093blatters
bleachers16297923bleachers
bleaters103412313bleat_ers
blethers13429613blethers
blithers134711233blithers
boaters93419233boat_ers
bothers124317753_bothers
breachers16369853breachers
breather133610593breather_
breathes134212903breathe_s
brothers133410823brothers
catchers153114053_catchers
caters85336493_cat_ers
centers94420593cent_ers
centners1057243centners
chatters134213933chatters
cheaters133613503cheat_ers
cithers124315753_cithers
clashers134213993clashers
clatters103313903clatters
coachers154312293coachers
coaters93525773coat_ers
crashers134013223crashers
craters95021883crat_ers
dashers115016863_dashers
daters74827363_dat_ers
dealers84118613dea_lers
deashes113313903deashe_s
deathbeds1642183deathbeds
deathless1335223deathless
deaths105914443death__s
debaters113511913debat_ers
detachers1536483detachers
deters74724683de_t_ers
dewaters122910713dewat_ers
diethers1257453diethers
dithers114016153_dithers
druthers1275793druthers
eagers74523683_ea_gers
earners74016453_earners
easters75125683_easters
eater54639843_eat_er_
eatery95316353_eat_ery
either94517423_either_
elaters74420183elat_ers
enters64425643_ent_ers
esters64627733_est_ers
etchers123411293_etchers
ether84518773_e_ther_
father125116713_father_
fearers104815273fea_rers
feasters11511563feasters
feater95224053feat_er_
feathered16188893feathered
features11310333features
festers104121393fest_ers
fetchers16328863fetchers
fetters103517903fe_tters
flashers143912653flashers
flatters113814203flatters
fraters103517203frat_ers
frothers14279803frothers
furthers1436493furthers
gaters74728633_gat_ers
gather104115853_gather_
getters84216093ge_tters
goatherd1335263goatherd
goatherds1444183goatherds
graters85419733grat_ers
hatchers163113173_hatchers
haters94930393_hat_ers
hatters104221523_hatters
headers113819393hea_ders
healers104319463hea_lers
heapers123616673hea_pers
hearers104319783hea_rers
heater94828303heat_er_
heathen133410893heathe_n
heathenry1843403heathenry
heathered16149463heathered
heathier1438343heathier_
heathless1535593heathless
heaths126316383heath__s
heatless113011463heatless
heavers133717193hea_vers
hefters134312003heft_ers
ingathers1344423ingathers
jesters144118193jest_ers
kashers143914023_kashers
kelters113813753kelt_ers
kraters114212333krat_ers
lashers104121833_lashers
lather95124353_lather_
lathery133911123_lathery
lathes95127493_lathe_s
leacher124014843leacher_
leaches123319343leache_s
leaders83819603lea_ders
leaguers935063leaguers
leakers113415423lea_kers
leaners73718173lea_ners
leapers93716663lea_pers
learners8398153learners
leasers74717843lea_sers
leashes103514403leashe_s
leathered13148713leathered
leavers103717783lea_vers
lechers123313963le_chers
lethes94818083le_the_s
letters73819853le_tters
loather103711003loather_
loathes103513243loathe_s
mashers124621053_mashers
matchers153012433_matchers
maters85032383_mat_ers
matters94421753_matters
meanders1168833meanders
meaners94415243mea_ners
meathead1436793meathead
meatheads1545963meatheads
meatier93214613meatier_
meatless103410863meatless
meeters94714543meet_ers
megathere1544723megathere
megatheres1644843megatheres
melters93918313melt_ers
metamers1249623metamers
meters85625833me_t_ers
metiers93312843me_tiers
mithers123516733_mithers
mothers123717623_mothers
mouthers133811303mouthers
murthers1336543murthers
natters73718063_natters
neatens73310403neat_ens
neater64424313neat_er_
neatness839153neatness
negaters9349773negat_ers
neither1037573neither_
nesters74422783nest_ers
nestlers8359223nestlers
nether94014163ne_ther_
netters73618583ne_tters
nettlers8307513nettlers
neuters74212263neut_ers
northers1139333northers
oaters65029783_oat_ers
others93918003__others
panthers13510783panthers
patchers153413303_patchers
paters84935823_pat_ers
patters94825193_patters
patzers184210573_patzers
peacher144216073peacher_
peaches144120053peache_s
peahens12307573pea_hens
pearlers1039023pearlers
peatier94017233peatier_
pelters93720313pelt_ers
perchers153611523perchers
pesters93827093pest_ers
peters86624593pe_t_ers
petters93722363pe_tters
pewters124113353pewt_ers
plashers133813453plashers
platers93924083plat_ers
platters103415283platters
pleaters103613783pleat_ers
pleather1356653pleather_
poachers152910763poachers
pothers123818623_pothers
praters94921643prat_ers
preachers16339573preachers
quashers20186803quashers
rashers104020903_rashers
raters63936573_rat_ers
rather94319733_rather_
ratters74422473_ratters
reacher123718293reacher_
reaches123423203reache_s
readers83823763rea_ders
realters83614043realters
reamers94221083rea_mers
reapers93520453rea_pers
rearers74323563rea_rers
reavers108320743rea_vers
rebaters103413913rebat_ers
regather1236733regather_
relaters83218143relat_ers
renters74224813rent_ers
rentiers83311763rentiers
resters74130403rest_ers
retakers123511133retakers
reutters8138563reutters
scathes124515713scathe_s
scatters103612753scatters
sealers74323553sea_lers
seamers94719433sea_mers
searchers14197353searchers
seater64534153seat_er_
seatless83213003seatless
seethes103613743seethe_s
seltzers1735063seltzers
setters73822063se_tters
settlers8289023settlers
shatters113313903shatters
sheather1458213sheather_
sheathes14610183sheathe_s
skaters113512943skat_ers
slashers113313603slashers
slaters73123723slat_ers
slather103816063slather_
slithers114212953slithers
smashers13339583smashers
smatters104011713smatters
smithers13369793smithers
smothers13349933smothers
snatchers14146303snatchers
snathes104816493snathe_s
soothers113913433soothers
southers114214453southers
spathes125116533spathe_s
spatters103914703spatters
staters73922323stat_ers
swashers14389523swashers
swather134213593swather_
swathes134115513swathe_s
swatters113911793swatters
swearers11328583swea_rers
sweater103712723sweat_er_
sweatier1147033sweatier_
swelters113110193swelt_ers
swithers144310533swithers
taters64932193_tat_ers
tatters74520483_tatters
teacher123714833teacher_
teaches122718353teache_s
tearers75218233tea_rers
teasers75317243tea_sers
teeters74018303teet_ers
teether10349693teether_
teethes103611653teethe_s
telphers1335473telphers
tenters73921103tent_ers
testers74124543test_ers
tether93716103te_ther_
tetters74320473te_tters
thatchers1744573thatchers
theaters114211893theat_ers
tithers104216733_tithers
trashers113013623trashers
treaters83615823treat_ers
tweeters11287143tweet_ers
upgathers1582523upgathers
vealers103214293vea_lers
venters103717723vent_ers
vetoers10359473ve_toers
vetters104016313ve_tters
wadders123812443w_adders
waders109120643w_a_ders
wafers124316143w_a_fers
wafters134112813w_afters
wagers105122203w_a_gers
waggers124613083w_aggers
wailers103916803w_ailers
waiters104218623w_aiters
waivers133410053w_aivers
wakers134822493w_a_kers
walers94824463w_a_lers
walkers143411473w_alkers
waltzers2034003waltzers
wanders114221333w_anders
wankers144514713w_ankers
wanters104420093w_anters
warders113416813w_arders
warmers124514293w_armers
warners103315563w_arners
warpers123413583w_arpers
washer124720393w_asher_
washes124425493w_ashe_s
wasters104026593w_asters
watcher153113403w_atcher_
watches153017373w_atche_s
water84733313w_at_er_
waterers112312783w_aterers
watery123914493w_at_ery
watter93221983w_atter_
wavers125022473w_a_vers
waxers164014303w_a_xers
weakeners1644163weakeners
weakens14367063wea_kens
weaker134015443wea_ker_
weakness1535353weakness
wealthier1543263wealthier_
wealths13365813wealth__s
weaner93816773wea_ner_
wearer94319403wea_rer_
wearier103613283wearier_
wearies103020223wearie_s
wears86030303wea___rs
weasels10468503wea_sels
weathercast19273653weathercast
weathering1798353weathering
weatherings1895253weatherings
weatherize2545843weatherize
weatherizes2645933weatherizes
weatherman1854243weatherman
weathermen1844503weathermen
weaver123916613wea_ver_
weaves123616373wea_ve_s
webers11310943we__bers
websters1335803websters
wedders123610723we_dders
weeders113412933we_eders
weepers123511973we_epers
weevers13379993we_evers
weigher14136343weigher_
weighters1644663weighters
weiners103913063we_iners
welcher15319393welcher_
welches153710313welche_s
welders113313413we_lders
welsher13377443welsher_
welshes13379093welshe_s
welter93417383welt_er_
wencher153811133wencher_
wenches152914133wenche_s
wester94222893west_er_
western102911093west_ern
westerns11328963west_erns
wetness10277723we_tness
wetter93919443we_tter_
whackers20326543whackers
whalers13529703wha_lers
whappers18276743whappers
whatness1435093whatness
wheatears1542673wheatears
wheatens1454663wheat_ens
wheatless1534003wheatless
whether16346623whether_
whetters14246653whetters
whither163510253whither_
whitters14359403whitters
winchers16319223winchers
winters103720473wint_ers
wishers133215213w_ishers
wither124321353w_ither_
withes124620843w_ithe_s
wrappers15306933wrappers
wrathed14298523wrathe_d
wrathier1435903wrathier_
wraths123810083wrath__s
wreakers15328423wrea_kers
wreathe13339053wreathe__
wreathed15257463wreathe_d
wreathen14256143wreathe_n
wreaths13338373wreath__s
wrenchers17256333wrenchers
wresters112711733wrest_ers
wrestlers12306103wrestlers
writers105513493writ_ers
writher134010853writher_
writhes134811703writhe_s
wuther124511613w_uther_
yatters103914623_yatters
yearners11346373yearners
zesters163517293zest_ers
zithers193911973_zithers

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 Filter1786911461620.266671770.7
2DLD Change Limit1461624557.89018525.0
3Display Results4554550.1862446.2
 (SQL Overall)1786914558.34221420.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.