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

191 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
leathern1139891(None) 
leather103815781leather_
leathers114215081leathers
leathery14438971leathery
feather133613502feather_
feathers143513242feathers
feathery17368072feathery
heathen133410892heathe_n
heather133914852heather_
heathers143914732heathers
heathery17349082heathery
lather95124352l_ather_
lathers104321882l_athers
lathery133911122l_athery
leacher124014842leacher_
leachers133712812leachers
leathered13148712leathered
leathering1488682leathering
lectern937032lect_ern
lethean1037092le_thean
loather103711002loather_
loathers113310432loathers
luthern1037652l_uthern
neatherd12107192neatherd
pleather1356652pleather_
pleathers1446452pleathers
weather133513222weather_
weathers143412832weathers
aether94213673ae_ther_
aethers103614943ae_thers
aweather1434263aweather_
bather115322513_bather_
bathers124720363_bathers
beaten84617063beat_e_n
beater84729393beat_er_
beaters94925033beat_ers
bethorn1238643be_thorn
blather125314203blather_
blathers134713793blathers
bleacher15358883bleacher_
bleachers16297923bleachers
bleater94515303bleat_er_
bleaters103412313bleat_ers
blether12459913ble_ther_
blethers13429613ble_thers
breather133610593breather_
breathers14319093breathers
cithern12489913_cithern
earthen1039253_earthe_n
eastern74412533_eastern
eaten55323053_eat_e_n
eater54639843_eat_er_
eaters65535943_eat_ers
eatery95316353_eat_ery
either94517423_either_
elater64724203elat_er_
elaterin849903elat_erin
elaters74420183elat_ers
ether84518773_e_ther_
ethers94518413_e_thers
extern1348473_ext_ern
father125116713_father_
fathers133916503_fathers
feater95224053feat_er_
feathered16188893feathered
feathering17108793feathering
gather104115853_gather_
gathers114315063_gathers
goatherd1335263goatherd
heater94828303heat_er_
heaters104225213heat_ers
heathenry1843403heathenry
heathens143210153heathens
heathered16149463heathered
heathier1438343heathier_
lantern7310013l_antern
lanthorn1147193lanthorn
lasher94824533l_asher_
lashers104121833l_ashers
lateen64014863l_at_een
laten54328343l_at_e_n
later54843923l_at_er_
lathe85626713l_athe__
lathed104718453l_athe_d
lathered121512323l_athered
latherer111310443l_atherer
lathering13912253l_athering
lathes95127493l_athe_s
lathier10310833l_athier_
latten65018203l_atte_n
latter65027893l_atter_
leached133715043leache_d
leaches123319343leache_s
leachier1337253leachier_
leaden74515223lea_de_n
leader74824653lea_der_
leaders83819603lea_ders
leadier83212723leadier_
leadmen10277903leadme_n
leafier10329833leafier_
leaguer835793leaguer_
leaguers935063leaguers
leaker104620073lea_ker_
leakers113415423lea_kers
leakier114010993leakier_
leaner64022193lea_ner_
leaners73718173lea_ners
leaper88118943lea_per_
leapers93716663lea_pers
learier73415663learier_
learn55322663lea___rn
learner7319383learner_
learners8398153learners
leaser65322673lea_ser_
leasers74717843lea_sers
leashed113211163leashe_d
leashes103514403leashe_s
leatherneck2051783leatherneck
leaven95013073lea_ve_n
leaver94321513lea_ver_
leavers103717783lea_vers
leavier10319993leavier_
lecher113415853le_cher_
lechers123313963le_chers
lechery15257643le_chery
lecterns1035943lect_erns
lefter93613433left_er_
leghorn1146223le_ghorn
lengthen1243533lengthe_n
lenten6312883lent_e_n
lethe85717303le_the__
lethes94818083le_the_s
letter63722583le_tter_
letters73819853le_tters
lither94520953l_ither_
loathe94211383loathe__
loathed11419443loathe_d
loathes103513243loathe_s
lutherns1136293l_utherns
meathead1436793meathead
meatier93214613meatier_
meatmen1138243meatme_n
megathere1544723megathere
neaten64214543neat_e_n
neater64424313neat_er_
neatherds1395773neatherds
neither1037573neither_
nether94014163ne_ther_
northern1145583northern
pattern93712053_pattern
peacher144216073peacher_
peachers153213843peachers
peahen113410133pea_he_n
peatier94017233peatier_
pleater93916333pleat_er_
pleaters103613783pleat_ers
rather94319733_rather_
reacher123718293reacher_
reachers133515723reachers
regather1236733regather_
regathers1336333regathers
repattern1143663repattern
seater64534153seat_er_
seaters74028933seat_ers
sheather1458213sheather_
sheathers1557543sheathers
slather103816063slather_
slathers113914773slathers
slattern837093slattern
southern11438913southern
swather134213593swather_
swathers144512073swathers
teacher123714833teacher_
teachers133212393teachers
teether10349693teether_
teethers11328713teethers
tether93716103te_ther_
tethers103815313te_thers
weathered16168513weathered
weathering1798353weathering
weatherly1844403weatherly
weatherman1854243weatherman
weathermen1844503weathermen
western102911093west_ern
wether123315393we_ther_
wethers135214693we_thers
wreathen14256143wreathe_n
wreather14268603wreather_
wreathers15257483wreathers
yestern10338633yest_ern
zithern19447023_zithern

Search took 10 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.203880251.2
2DLD Change Limit1461621918.79616616.9
3Display Results1911910.0762513.2
 (SQL Overall)1786911919.07519690.5
 
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.