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

107 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
enterable1131264(None) 
alterable1149162alterable
endurable1247732endurable
enteral73516442entera_l_
enterally12410012enterally
enumerable1444972enumerable
generable1238662gen_erable
inferable14411272inferable
integrable1348402integrable
penetrable1446042penetrable
renderable1397152renderable
untenable11410502untenable
utterable1147152utterable
venerable1438482ven_erable
adherable1545003adherable
alterably1447203alterably
answerable1544153answerable
biteable1237933bite_able
censurable1445653censurable
citeable1238413cite_able
coverable1649103coverable
dateable1149443date_able
denumerable1653133denumerable
deterrable1345723deterrable
eatable91717603eat__able
enable83318483en___able
enactable1338493enactable
encodable1446273encodable
endorsable1344583endorsable
endurably1545673endurably
enfeeble13103223enfe_eble
enjoyable2143743enjoyable
ensemble1244973ense_mble
entera64216833entera___
enthral103410933enthra_l_
enthrall11266833enthra_ll
enthralled1443693enthralled
enthralls12256133enthralls
enthrals11278903enthra_ls
entrails8310163ent_rails
entrance10311333ent_rance
enviable1337853en_viable
errable9312183e__rrable
esterase849483estera_se
estimable1346043estimable
execrable2046233execrable
exorable1738933e_xorable
extendable2043833extendable
eyeable1239063e_ye_able
filterable1543723filterable
hateable1339373hate_able
inalterable1355233inalterable
inarable10313133in_arable
incurable131010773incurable
indexable1947033indexable
inerrable11410163inerrable
inferably1749023inferably
injurable18117413injurable
inoperable1448183inoperable
insurable111011093insurable
interage9314493intera_ge
interfile12411043interfile
intermale11712303intermale
intervale12911593intervale
intolerable1355433intolerable
lacerable1346943lacerable
mensurable1445453mensurable
miserable1349653miserable
nettable101610243net_table
numerable1347623numerable
operable12410323_operable
orderable1246183orderable
overable13513573_overable
ponderable1546083ponderable
rateable10311443rate_able
referable1439623referable
renewable1447433ren_ewable
rentable101716333rent__able
restorable1246753restorable
reverable14310363reverable
saturable1146633saturable
severable1438543severable
steerable1146913steerable
stewable1337133_stewable
storable10310733_storable
superable13312483superable
tearable101512673__tearable
temperable1645813temperable
tenable93214493__tenable
tenurable1147423ten_urable
titrable1038963tit_rable
tolerable1147393tolerable
toteable1048353tote_able
unalterable1345773unalterable
unbearable1447383unbearable
uncurable13710073uncurable
unhirable1447643unhirable
unseeable1149453unseeable
untamable1347843untamable
untenably1447533untenably
untestable1248823untestable
untunable1147833untunable
unutterable1354053unutterable
unwearable1547213unwearable
venerables1544353ven_erables
venerably1746423ven_erably
voteable1347213vote_able

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.420425454.8
2DLD Change Limit1486411076.72022119.2
3Display Results1071070.0462326.1
 (SQL Overall)1786911077.18624866.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.