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

217 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
meltable1231047(None) 
beatable121612242beatable
deletable12149502deletable
eatable91717602_eatable
fellable13179132fellable
gelable101710732gel_able
getable101712552ge_table
gettable11178132gettable
heatable131612042heatable
helpable1536612helpable
meltage1037952melta_ge
mendable131510582mendable
millable121710132millable
moldable1337102moldable
mutable11312302m_utable
nestable101613672nestable
nettable101610242nettable
pettable121710712pettable
relatable11310052relatable
reliable10313072reliable
rentable101716332rentable
restable101618442restable
retable91820402re_table
sellable101711822sellable
tellable10169772tellable
testable101412622testable
tiltable10159012tiltable
weldable1436872weldable
wettable13148042wettable
abatable1238023abatable
actable11313473_actable
agitable1138583agitable
alliable1038433alliable
amenable1238863ame_nable
amendable1446053amendable
avertable14117343avertable
bearable121512363bearable
beddable14166923beddable
bendable131510853bendable
billable12179503billable
bitable11312203_bitable
boatable121610263boatable
bootable12179223bootable
callable12310753callable
cartable121314093cartable
castable121613973castable
cheatable1646713cheatable
chelatable1743613chelatable
citable11313463_citable
creatable1339563creatable
culpable1436283culpable
cuttable1247953cuttable
datable101714233_datable
debatable1446313debatable
delayable1546063delayable
delectable15247383delectable
delegable13136643delegable
deniable11312083deniable
denotable1238373denotable
depletable1544973depletable
deputable1487043deputable
dilatable1246853dilatable
eatables10169793_eatables
editable11310423editable
effable15106673_effable
ejectable20136573ejectable
electable13149623electable
emendable1446233emendable
emptiable1544843emptiable
enable83318483_e_nable
equable1849253_equable
erectable131210093erectable
errable9312183_errable
evitable1339323evitable
eyeable1239063_eyeable
feedable1437673feedable
fileable13179223fileable
fillable13179573fillable
filmable15157133filmable
filtrable1484263filtrable
fittable1337093fittable
flyable15307123_flyable
foldable1437133foldable
getatable1235953getatable
giftable1465893giftable
gullable1136463gullable
gustable11138203gustable
hatable121713963_hatable
healable131610183healable
hearable131611613hearable
heritable1439453heritable
hewable15177823he_wable
hittable1336853hittable
holdable1437073holdable
huntable1338093huntable
imitable1239123imitable
immutable1545593immutable
imputable1546683imputable
instable10313203instable
keepable1635323keepable
killable14168133killable
lamentable1444203lamentable
leasable101510133leasable
lendable11169463lendable
leviable1337513leviable
liable81415813__liable
liftable1376863liftable
listable10810313listable
mailable1239623mailable
makable15510203m_akable
makeable1637253makeable
malleable1376073malleable
maltase938903malta_se
mappable1635923mappable
maskable1638003maskable
measle83513223me__asle
meatal84114733meata_l_
meatball1244513meatball
medicable1647503medicable
melange1038363mel_ange
meltages1148243meltages
memorable1547533memorable
mental84521603menta_l_
mentally131010403mentally
metage93114453me_ta_ge
metal75427383me_ta_l_
metaled102913883me_ta_led
metalled1148993me_talled
metals84520893me_ta_ls
metastable1444923metastable
metate82720533me_ta_te
mettle83815723me_t_tle
minable112315073m_inable
mineable121611053mineable
missable12311533missable
mixable18259173m_ixable
mockable1846643mockable
mountable1346303mountable
movable14189433m_ovable
moveable15168013moveable
multiple12118303multiple
mutably1438613m_utably
notable92114903_notable
palatable1346383palatable
palpable1448033palpable
peccable1648123peccable
peelable1238563peelable
peltate92013773pelta_te
pentacle1239383pentacle
pliable111610323_pliable
portable12313203portable
potable112115363_potable
quellable2043673quellable
quotable1936493quotable
ratable91717553_ratable
readable11313163readable
reapable12311393reapable
reefable1339533reefable
reelable10311603reelable
refutable1477863refutable
relabel938163rel_abel
relaxable1836363relaxable
relegable1258103relegable
reliables1145903reliables
reliably1339243reliably
relivable1438513relivable
reputable1379123reputable
restabled12148963restabled
restables111511423restables
retables101712673re_tables
reusable10811273reusable
rulable9310533rul_able
rustable101511363rustable
salable91415463sal_able
saleable10312023saleable
salvable1338403salvable
sealable101512693sealable
seeable91113943se_eable
seisable10311373seisable
seizable1938723seizable
selectable14136443selectable
sendable111612043sendable
servable13310093servable
sewable121911173se_wable
solvable1337473solvable
sortable10312483sortable
stable83921643__stable
statable10310703statable
suitable10310893suitable
syllable13177773syllable
table75429603___table
talkable1437193talkable
tastable101511973tastable
tearable101512673tearable
teasable101511173teasable
telltale844423tellta_le
temptable1545813temptable
tenable93214493te_nable
tentacle1037693tentacle
tillable10159753tillable
timetable1346873time_table
totable92313363_totable
treatable1139323treatable
uneatable11311693uneatable
unstable10313763unstable
valuable1336863valuable
vegetable1545683vegetable
vendable14159693vendable
veritable1448743veritable
votable122111373_votable
walkable1736063walkable
wastable131410453wastable
wearable131510563wearable
wieldable1543823wieldable
willable13168683willable
writable1338753writable
yieldable1543353yieldable

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 Limit1461622177.45319611.2
3Display Results2172170.0932333.3
 (SQL Overall)1786912177.96922423.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.