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 “electable” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

96 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
electable1314962(None) 
delectable15247381delectable
ejectable20136571ejectable
erectable131210091erectable
selectable14136441selectable
deflectable1943802deflectable
delectables16144332delectables
delectably18125682delectably
deletable12149502dele_table
detectable15136602detectable
enactable1338492enactable
exactable2046432exactable
execrable2046232execrable
executable2144032executable
expectable2345062expectable
resectable1478122resectable
unelectable1546752unelectable
actable11313473__actable
affectable2043613affectable
avertable14117343avertable
beatable121612243_beatable
bleachable1943383bleachable
blockable1944303blockable
cheatable1646713cheatable
checkable2244743checkable
cleanable1345203cleanable
clearable1346013clearable
cleavable1644473cleavable
clickable1944303clickable
collectable17104903collectable
creatable1339563creatable
delectate1248743delecta_te
delegable13136643dele_gable
depletable1544973deple_table
detestable13136503detestable
eatable91717603__eatable
editable11310423e_ditable
educable1337093educ_able
electee92513243elect__ee
elective13311003elect_ive
electrode1247013electrode
emendable1446233emendable
equatable2045193equatable
equitable2046193equitable
erectile1039513erect_ile
evitable1339323e_vitable
evocable1537103evoc_able
excitable2056243excitable
execrably2344123execrably
expectably2654223expectably
eyeable1239063eye__able
flickable2043983flickable
floatable1444983floatable
getable101712553_ge_table
gettable11178133_gettable
gleanable1244083gleanable
heatable131612043_heatable
ineluctable1545413ineluctable
inflectable1845123inflectable
injectable2147003injectable
leachable16136443leachable
leasable101510133_leasable
lendable11169463_lendable
leviable1337513_leviable
liftable1376863_liftable
listable10810313_listable
locatable1345573_locatable
lockable1636953_lockable
meltable12310473_meltable
nestable101613673_nestable
nettable101610243_nettable
peccable1648123_peccable
pettable121710713_pettable
placable14169243plac_able
placeable1536913placeable
plantable1337273plantable
pleadable1445513pleadable
relatable11310053rel_atable
releasable1245483releasable
relegable1258103rele_gable
relocatable1542863relocatable
rentable101716333_rentable
repeatable1447603repeatable
resettable1256513resettable
respectable1755043respectable
restable101618443_restable
retable91820403_re_table
sliceable1345443sliceable
spectacle1544083spectacle
testable101412623_testable
tractable1338513tractable
treatable1139323treatable
unactable13310053unactable
uneatable11311693uneatable
vegetable1545683vege_table
wettable13148043_wettable

Search took 7 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.420425454.8
2DLD Change Limit148641966.28323657.6
3Display Results96960.0303200.0
 (SQL Overall)178691966.73326539.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.