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

128 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
reparable135995(None) 
repairable1445951repairable
reparably1656351reparably
repayable1666341repayable
separable1348671separable
bearable121512362be_arable
hearable131611602he_arable
irreparable1584432irreparable
parable111819772__parable
readable11313162re_adable
reapable12311392re_apable
referable1439622referable
relatable11310052relatable
relaxable1836362relaxable
remarkable1844082remarkable
repealable1445982repealable
repeatable1447602repeatable
reportable1446952reportable
reputable1379122reputable
resalable1138732resalable
respirable1446022respirable
reverable14310362reverable
rewardable1643882rewardable
separably1655772separably
sparable121611982_sparable
tearable101512672te_arable
wearable131510552we_arable
arable81821003___arable
bearably15177933be_arably
beatable121612243be_atable
breakable1746163bre_akable
clearable1346013clearable
comparable1845603comparable
creatable1339563cre_atable
debatable1446313debatable
decayable1745623decayable
declarable1544973declarable
delayable1546063delayable
deplorable1545073deplorable
deportable1545653deportable
deposable1446833deposable
deputable1487043deputable
desirable1249393desirable
eatable91717603_e_atable
erasable10511043_erasable
errable9312183_e_rrable
evadable1436363_evadable
exorable1738933_exorable
generable1238663generable
getatable1235953getatable
healable131610173he_alable
heatable131612043he_atable
inarable10313133_inarable
inseparable1545613inseparable
irreparably1884083irreparably
learnable1145563le_arnable
leasable101510133le_asable
memorable1547533memorable
nonarable1149053nonarable
operable12410323_operable
parables121613563__parables
parsable12311693__parsable
payable141711323__payable
preferable1746723preferable
propagable1743353propagable
ratable91717553r__atable
reachable16129653reachable
readably1438383re_adably
recallable1445373recallable
recappable1843723recappable
recordable1545553recordable
reefable1339533re_efable
reelable10311593re_elable
refinable1438623refinable
reformable1745293reformable
refusable1476683refusable
refutable1477863refutable
regulable1246513regulable
releasable1245483releasable
relegable1258103relegable
reliable10313073re_liable
relivable1438513relivable
remarkably2152583remarkably
removable1646923removable
renderable1397153renderable
renewable1447433renewable
rentable101716333re_ntable
reparative1548173reparative
repartee10312753repar_tee
rephrase1346733rephra_se
replaceable1743223replaceable
replicable1646623replicable
reprobe112310133rep_rob_e
reputably1686453reputably
rescuable1347583rescuable
resealable1246183resealable
reservable1546373reservable
restable101618443re_stable
restartable1343543restartable
restorable1246753restorable
resumable1347553resumable
retable91820403re__table
returnable1244793returnable
reusable10811273re_usable
revealable1545083revealable
revisable1437993revisable
revivable1736863revivable
revocable1647003revocable
revokable1845293revokable
rippable1435383rip_pable
ropable111611333rop__able
rotatable1146653rotatable
sealable101512693se_alable
securable1347773securable
separate10310783separa_te
severable1438543severable
sharable131910693_sharable
sparables13167163_sparables
spareable1337263_spareable
speakable1745373speakable
superable13312483superable
teasable101511173te_asable
temperable1645813temperable
tenurable1147423tenurable
treatable1139323tre_atable
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 Limit1486411287.75019179.5
3Display Results1281280.0632031.7
 (SQL Overall)1786911288.23621696.3
 
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.