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

153 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
feathery1736807(None) 
feather133613501feather_
feathers143513241feathers
heathery17349081heathery
leathery14438971leathery
eatery95316352_eat_ery
father125116712f_ather_
fatherly1745072f_atherly
fathers133916502f_athers
feater95224052feat_er_
feathered16188892feathered
flattery14338292flattery
heathenry1843402heathenry
heather133914852heather_
heathers143914732heathers
lathery133911122_lathery
leather103815782leather_
leathern11398912leathern
leathers114215082leathers
neatherd12107192neatherd
weather133513222weather_
weatherly1844402weatherly
weathers143412832weathers
aether94213673ae_ther_
aethers103614943ae_thers
aweather1434263aweather_
bather115322513_bather_
bathers124720363_bathers
battery124911813_battery
beanery1237563bea_nery
beater84729393beat_er_
beaters94925043beat_ers
blather125314203blather_
blathers134713793blathers
breather133610593breather_
breathers14319103breathers
cattery123811603_cattery
chattery16357273chattery
clattery13378193clattery
deanery1137613dea_nery
deathly14336863death_ly
deathy134210233death__y
diathermy1842573diathermy
dithery14318943_dithery
eater54639843_eat_er_
eaters65535953_eat_ers
either94517423_either_
ether84518773_e_ther_
ethers94518413_e_thers
faery116015483f_a__ery
fakery16509263f_a_kery
farther1348343farther_
fathead1437863f_athead
fathered151510433f_athered
fatter94523213f_atter_
fearer94820183fea_rer_
fearers104815273fea_rers
feaster10812983feaster_
feasters11511563feasters
featest102715113feat_est
featherbed19174663featherbed
featherier1645803featherier
feathering17108793feathering
featlier1136453featlier_
featly123711753feat__ly
feature1039853feat_ure
featured1237683featured
features11310333features
fernery1335813fe_rnery
fester94723513fest_er_
festers104121393fest_ers
fetcher153510393fetcher_
fetchers16328863fetchers
fetter94120383fe_tter_
fetters103517903fe_tters
fishery16397733f_ishery
flackery20295243flackery
flasher133914063flasher_
flashers143912653flashers
flathead1535803flathead
flatter103815963flatter_
flatters113814203flatters
fluttery14376143fluttery
frater94520593frat_er_
fraters103517213frat_ers
frother133110153frother_
frothers14279813frothers
further1337003further_
furthers1436493furthers
gather104115853_gather_
gathers114315073_gathers
goatherd1335263goatherd
hatchery19326383_hatchery
heater94828303heat_er_
heaters104225223heat_ers
heathen133410893heathe_n
heathens143210153heathens
heathered16149463heathered
heathier1438343heathier_
heathy156111213heath__y
lather95124353_lather_
lathers104321883_lathers
leacher124014843leacher_
leachers133712813leachers
leathered13148713leathered
lechery15257643le_chery
loather103711003loather_
loathers113310443loathers
mattery123810713_mattery
meathead1436793meathead
meatier93214613meatier_
megathere1544733megathere
mothery153710513_mothery
neater64424313neat_er_
neatherds1395773neatherds
neither1037573neither_
nether94014163ne_ther_
peacher144216073peacher_
peachers153213843peachers
peatier94017233peatier_
pleather1356653pleather_
pleathers1446453pleathers
rather94319743_rather_
reacher123718293reacher_
reachers133515723reachers
regather1236733regather_
regathers1336353regathers
sealery104011053sea_lery
seater64534153seat_er_
seaters74028943seat_ers
sheather1458233sheather_
sheathers1557553sheathers
slather103816073slather_
slathers113914783slathers
slithery14356703slithery
smithery16325703smithery
smothery16296063smothery
swather134213603swather_
swathers144512083swathers
teacher123714833teacher_
teacherly1743513teacherly
teachers133212393teachers
teether10349693teether_
teethers11328713teethers
tether93716103te_ther_
tethers103815313te_thers
treachery1744693treachery
watery123914493_wat_ery
weathered16168513weathered
wether123315393we_ther_
wethers135214693we_thers
wreather14268603wreather_
wreathers15257493wreathers

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.1701051123.5
2DLD Change Limit1461621536.79621507.1
3Display Results1531530.0463326.1
 (SQL Overall)1786911537.01225483.6
 
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.