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

200 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
eatables1016979(None) 
eatable91717601eatable_
ratables10159721ratables
arables91814972_arables
beatable121612242beatable_
datable101714232datable_
enables92813122e_nables
hatable121713962hatable_
heatable131612042heatable_
notables10178242notables
parables121613562parables
payables15166482payables
potables12179702potables
ratable91717552ratable_
restables111511422restables
retables101712672retables
stables93219072_stables
tables84524892__tables
taxables1734382taxables
wearables14155002wearables
abatable1238023abatable_
ables75935543___ables
actable11313473actable_
ambles105121863_a_mbles
anableps1243123_anableps
arable81821003_arable_
atabals938413_atabals
ataxies142410013_ataxies
babbles104416323ba_bbles
battles94517683bat_tles
baubles113611863ba_ubles
bearable121512363bearable_
bitable11312203bitable_
boatable121610263boatable_
breakables1842753breakables
cables104527553__cables
cantabiles1445763cantabiles
capable13313363capable_
capabler1435353capabler
capablest1544893capablest
cartable121314093cartable_
cascables15165773cascables
castable121613973castable_
cataloes10311653cataloes
catalos9414163cata_los
cheatable1646713cheatable_
citable11313463citable_
creatable1339563creatable_
dabbles124514773da_bbles
database1143533database
databases1243913databases
dataries9314033dataries
dateable1149443dateable_
debatable1446313debatable_
disables11410903disables
durables11237013durables
eagles73819163e__agles
earaches13411303earaches
eateries8324313eateries
ectases92911673ecta_ses
edibles1048003e_dibles
editable11310423editable_
educables1443473educables
effable15106673effable_
empales112411433empa_les
enable83318483e_nable_
enabled102510633e_nabled
enabler9299363e_nabler
enablers10196913e_nablers
enactable1338493enactable_
ennobles1045113ennobles
entailed989523entailed
entailer877833entailer
entailers976413entailers
entails7912823entail_s
entangles1075563entangles
entases72816273enta_ses
entitles8710663entitles
equable1849253equable_
equatable2045193equatable_
erasable10511043erasable_
errable9312183errable_
establish1444743establish
estates74520183esta_tes
etapes85415293e_ta_pes
etoiles7411293e_toiles
eutaxies1545793eutaxies
evadable1436363evadable_
evitable1339323evitable_
exactable2046433exactable_
exhales1737143exha_les
eyeable1239063eyeable_
fables114921673__fables
fadable13310463fadable_
gabbles124415413ga_bbles
gables94222333__gables
gambles124016203ga_mbles
garbles104016923ga_rbles
gazaboes2043863gazaboes
getable101712553getable_
getatable1235953getatable_
gettable11178133gettable_
giftables1572593giftables
gustables12165223gustables
hateable1339373hateable_
healable131610173healable_
hearable131611603hearable_
jacales16310323jaca_les
lavaboes1344433lavaboes
leasable101510133leasable_
makable15510203makable_
manacles1239523manacles
marbles114516653ma_rbles
meatballs1344093meatballs
meltable12310473meltable_
movables15175573movables
mutable11312303mutable_
namable11312343namable_
nestable101613673nestable_
nettable101610243nettable_
notable92114903notable_
outfables1485563outfables
parable111819773parable_
payable141711323payable_
pentacles1338773pentacles
pettable121710713pettable_
portables1337873portables
potable112115363potable_
rabbles113517973ra_bbles
rambles113118313ra_mbles
ratably121711513ratabl_y
ratafees1144143ratafees
ratals64219583rata_l_s
ratanies8312923ratanies
rateable10311443rateable_
ratholes11312413ratholes
rattles73217303rat_tles
readable11313163readable_
reapable12311393reapable_
relatable11310053relatable_
reliables1145903reliables
rentable101716333rentable_
restable101618443restable_
restabled12148963restabled
retable91820403retable_
reusables1175223reusables
sables85026693__sables
salable91415463salable_
satiable10310733satiable_
savable121711863savable_
sayable121411613sayable_
sealable101512693sealable_
sparables13167163sparables
stabiles10311403_stabiles
stable83921643_stable_
stabled103514953_stabled
stabler94014933_stabler
stablers103611153_stablers
stablest103312943_stablest
stales65538293_sta_les
staples93617213_staples
statable10310703statable_
tabes76033923__tab_es
tablas83716163__tablas
table75429603__table_
tabled94020043__tabled
tablet84227643__tablet
tablets94714383__tablets
takable13310193takable_
tales55451373__ta_les
tamable11312853tamable_
tamales93216153tama_les
tastable101511973tastable_
tattles73616283tat_tles
taxable1639073taxable_
tearable101512673tearable_
teasable101511173teasable_
tentacles1146713tentacles
testable101412623testable_
totable92313363totable_
treatable1139323treatable_
uneatable11311693uneatable_
valuables1442973valuables
variables1444673variables
vegetables1642703vegetables
vendables15165153vendables
vocables15145733vocables
votable122111373votable_
wabbles144013993wa_bbles
wadable13310233wadable_
wambles143714023wa_mbles
warbles123215563wa_rbles
washables17144743washables
wastable131410453wastable_
watapes12228383wata_pes
watchables2043203watchables
wattles103814073wat_tles
waxable1937673waxable_
wearable131510553wearable_
wettable13148043wettable_

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.406440125.6
2DLD Change Limit1461622008.03318195.2
3Display Results2002000.0762631.6
 (SQL Overall)1786912008.51520985.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.