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

115 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
separable134867(None) 
reparable1359951reparable
separably1655771separably
sparable121611981s_parable
bearable121512362be_arable
hearable131611602he_arable
inseparable1545612inseparable
parable111819772__parable
repairable1445952repairable
reparably1656352reparably
repayable1666342repayable
sealable101512692se_alable
securable1347772securable
separate10310782separa_te
severable1438542severable
sharable131910692s_harable
sparables13167162s_parables
spareable1337262s_pareable
speakable1745372speakable
superable13312482superable
tearable101512672te_arable
wearable131510552we_arable
arable81821003___arable
bearably15177933be_arably
beatable121612243be_atable
clearable1346013clearable
comparable1845603comparable
debatable1446313debatable
decayable1745623decayable
declarable1544973declarable
delayable1546063delayable
deplorable1545073deplorable
deportable1545653deportable
deposable1446833deposable
deputable1487043deputable
desirable1249393desirable
eatable91717603_e_atable
erasable10511043_erasable
errable9312183_e_rrable
escapable1544983escapable
evadable1436363_evadable
exorable1738933_exorable
generable1238663generable
getatable1235953getatable
healable131610173he_alable
heatable131612043he_atable
inarable10313133_inarable
inseparables1652523inseparables
inseparably1854753inseparably
irreparable1584433irreparable
learnable1145563le_arnable
leasable101510133le_asable
memorable1547533memorable
nonarable1149053nonarable
operable12410323_operable
parables121613563__parables
parsable12311693__parsable
payable141711323__payable
readable11313163re_adable
reapable12311393re_apable
referable1439623referable
relatable11310053relatable
relaxable1836363relaxable
remarkable1844083remarkable
repealable1445983repealable
repeatable1447603repeatable
reportable1446953reportable
reputable1379123reputable
resalable1138733resalable
respirable1446023respirable
reverable14310363reverable
rewardable1643883rewardable
salable91415463s__alable
saturable1146633saturable
savable121711863s__avable
sayable121411613s__ayable
scalable121710233s_calable
searchable1744143se_archable
seeable91113943se__eable
seisable10311373se_isable
seizable1938723se_izable
sellable101711823se_llable
semblable1544843semblable
sendable111612043se_ndable
separated1237713separated
separately1553433separately
separates11310743separates
separative1546973separative
separator1146263separator
servable13310093se_rvable
sewable121911173se__wable
shakable17177683s_hakable
shamable15168803s_hamable
shapable15197803s_hapable
shapeable1645743shapeable
shareable1436733s_hareable
shavable16177273s_havable
slakable14177553s_lakable
slayable13157563s_layable
spallable1345833s_pallable
sparkle133710213s_par_kle
spendable1446463spendable
spiracle1255803s_piracle
statable10310703s_tatable
stealable1136573stealable
steerable1146913steerable
storable10310733s_torable
superably1648883superably
swayable16135533s_wayable
teasable101511173te_asable
temperable1645813temperable
tenurable1147423tenurable
vaporable1645543vaporable
venerable1438483venerable
wearables14155003we_arables

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.423422437.4
2DLD Change Limit1486411158.26317988.7
3Display Results1151150.0631825.4
 (SQL Overall)1786911158.74920424.2
 
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.