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

95 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
securable134777(None) 
curable112414512__curable
incurable131010772incurable
saturable1146632saturable
securance1345872securance
separable1348672separable
severable1438542severable
tenurable1147422tenurable
uncurable13710072uncurable
accruable1543603accruable
accusable1544873accusable
assurable1146013assurable
bearable121512363be_arable
censurable1445653censurable
curably142010773__curably
curbable1447663__curbable
decayable1745623decayable
decidable1547223decidable
declarable1544973declarable
deputable1487033deputable
desirable1249393desirable
durable102312723__durable
educable1337083_educable
endurable1247733endurable
equable1849253_equ_able
errable9312183_e_rrable
escapable1544983escapable
excusable2044373excusable
execrable2046233exec_rable
executable2144033executable
exorable1738933_exorable
figurable1543733figurable
focusable1644093focusable
generable1238663generable
hearable131611603he_arable
incunable13108743incunable
incurables14105143incurables
incurably16119063incurably
injurable18117413injurable
insurable111011083insurable
lacerable1346943lacerable
measurable1444723measurable
memorable1547533memorable
mensurable1445453mensurable
peccable1648103pec_cable
perdurable1544753perdurable
perusable1347453perusable
pourable1239133_pourable
procurable1644863procurable
recordable1545553recordable
recoupable1645023recoupable
referable1439623referable
refusable1476683refusable
refutable1477863refutable
regulable1246513regulable
reparable1359953reparable
reputable1379123reputable
rescuable1347583rescu_able
resumable1347553resumable
returnable1244793returnable
reusable10811273re_usable
reverable14310363reverable
scalable121710233s_calable
scrabble14196993s_c_rabble
scramble14177253s_c_ramble
scrutable1346043scrutable
scumble1337013s_cu_mble
scurrile1055063s_currile
sealable101512693se_alable
secularly1445223secularly
securances1445743securances
secure8513533secur___e
securely1345063secur_ely
seducible1443333seducible
seeable91113943se__eable
seisable10311373se_isable
seizable1938723se_izable
sellable101711823se_llable
semblable1544843semblable
sendable111612043se_ndable
separably1655773separably
servable13310083se_rvable
sewable121911173se__wable
sharable131910693s_harable
sociable1239503soc_iable
sparable121611973s_parable
steerable1146913steerable
storable10310733s_torable
suable83920553s__u_able
superable13312483superable
surfable1338443s__urfable
tearable101512673te_arable
uncurably1697793uncurably
venerable1438483venerable
wearable131510553we_arable

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 Filter1786911486410.1561145455.1
2DLD Change Limit148641958.12618292.0
3Display Results95950.0462065.2
 (SQL Overall)178691958.32821456.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.