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

117 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
erectable13121009(None) 
ejectable20136571ejectable
electable13149621electable
creatable1339562creatable
delectable15247382delectable
detectable15136602detectable
enactable1338492enactable
erectile1039512erect_ile
exactable2046432exactable
execrable2046232execrable
executable2144032executable
expectable2345062expectable
rentable101716332_rentable
resectable1478122resectable
restable101618442_restable
retable91820402_re_table
selectable14136442selectable
tractable1338512tractable
treatable1139322treatable
actable11313473__actable
affectable2043613affectable
avertable14117343avertable
beatable121612243_beatable
breakable1746163breakable
breathable1744143breathable
cheatable1646713cheatable
checkable2244743checkable
correctable1745233correctable
creditable1546003creditable
deflectable1943803deflectable
delectables16144333delectables
delectably18125683delectably
deletable12149503dele_table
depreciable1854553depreciable
detestable13136503detestable
draftable1575563draftable
eatable91717603__eatable
editable11310423e_ditable
educable1337093educ_able
emendable1446233emendable
equatable2045193equatable
equitable2046193equitable
erasable10511043er_asable
erective13311833erect_ive
erectly1257473erect__ly
erodable1139203er_odable
errable9312183er__rable
eructate1047333eructa_te
eruptible1342923eruptible
evitable1339323e_vitable
evocable1537103evoc_able
excitable2056243excitable
execrably2344123execrably
expectably2654223expectably
extractable2254153extractable
eyeable1239063eye__able
fermentable1844073fermentable
freezable2345093freezable
getable101712553_ge_table
gettable11178133_gettable
grantable1257293grantable
heatable131612043_heatable
heritable1439453her_itable
injectable2147003injectable
irritable1148053irritable
meltable12310473_meltable
nestable101613673_nestable
nettable101610243_nettable
peccable1648123_peccable
perfectible2053433perfectible
permutable1644983permutable
pettable121710713_pettable
predictable1844993predictable
pregnable1456693pregnable
previable1647533previable
priceable1546823priceable
printable1338203printable
projectable2452903projectable
ratable91717553_r_atable
reachable16129653reachable
readable11313163_readable
reapable12311393_reapable
rectal84418133_recta_l_
rectally1339713_rectally
rectangle1244263_rectangle
reefable1339533_reefable
reelable10311593_reelable
refutable1477863refutable
regrettable1452983regrettable
relatable11310053relatable
reliable10313073_reliable
repeatable1447603repeatable
reputable1379123reputable
rescuable1347583rescuable
resettable1256513resettable
respectable1755043respectable
restabled12148953_restabled
restables111511423_restables
retables101712673_re_tables
retractable1545123retractable
reusable10811273_reusable
rockable1638013_rockable
rustable101511363_rustable
spectacle1544083spectacle
testable101412623_testable
traceable1338323traceable
trackable1736743trackable
tractably1646243tractably
truckable1744513truckable
trustable1147123trustable
unactable13310053unactable
uneatable11311693uneatable
unelectable1546753unelectable
vegetable1545683vege_table
veritable1448743ver_itable
wettable13148043_wettable
writable1338753wr_itable

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 Filter1786911486410.1561145455.1
2DLD Change Limit1486411177.36020195.8
3Display Results1171170.0601950.0
 (SQL Overall)1786911177.57623586.5
 
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.