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

123 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
resalable113873(None) 
resealable1246181resealable
healable131610172he_alable
readable11313162re_adable
reapable12311392re_apable
recallable1445372recallable
reelable10311592re_elable
regulable1246512regulable
relatable11310052relatable
relaxable1836362relaxable
reparable1359952reparable
repayable1666342repayable
repealable1445982repealable
rescuable1347582rescuable
resoluble1144142resoluble
resolvable1544582resolvable
restable101618442res_table
resumable1347552resumable
revealable1545082revealable
salable91415462__salable
sealable101512692se_alable
unsalable1148992unsalable
assailable1243433assailable
assayable1443643assayable
bearable121512363be_arable
beatable121612243be_atable
breakable1746163bre_akable
creatable1339563cre_atable
debatable1446313debatable
decayable1745623decayable
delayable1546063delayable
desirable1249393desirable
eatable91717603_e_atable
erasable10511043_erasable
escapable1544983_escapable
evadable1436363_evadable
evaluable1444233_evaluable
exilable1737203_exilable
fellable13179133fe_llable
gelable101710733ge__lable
getatable1235953getatable
hearable131611603he_arable
heatable131612043he_atable
isolable1038793_isolable
leasable101510133le_asable
nestable101613673nes_table
nonsalable1245663nonsalable
peelable1238553pe_elable
presumable1645203presumable
ratable91717553r__atable
reachable16129653reachable
readably1438383re_adably
realizable2145333re_alizable
reasonable1246283reasonable
rebalance1345763rebalance
recappable1843723recappable
recyclable1943643recyclable
reefable1339533re_efable
referable1439623referable
refillable1544073refillable
refinable1438623refinable
refusable1476683refusable
refutable1477863refutable
relabel938163re__label
releasable1245483releasable
relegable1258103relegable
reliable10313073re_liable
relivable1438513relivable
remarkable1844083remarkable
removable1646923removable
renewable1447433renewable
rentable101716333re_ntable
repairable1445953repairable
reparably1656353reparably
repeatable1447603repeatable
reputable1379123reputable
resaddle10115223resa_ddle
resale64025543res__a_le
resalute857413resal_ute
resample1244673resa_mple
rescale93215473res_ca_le
resectable1478123resectable
resemble1247313res_emble
reservable1546373reservable
resettable1256513resettable
reslate73520593res_la_te
respirable1446023respirable
restabled12148963res_tabled
restables111511423res_tables
restartable1343543restartable
restorable1246753restorable
retable91820403re__table
reusable10811273re_usable
reverable14310363reverable
revisable1437993revisable
revivable1736863revivable
revocable1647003revocable
revokable1845293revokable
revolvable1843513revolvable
rewardable1643883rewardable
rotatable1146653rotatable
rulable9310533r__ulable
rustable101511363rus_table
sailable10310563__sailable
salably121610743__salably
saleable10312023__saleable
salvable1338403__salvable
savable121711863__savable
sayable121411613__sayable
scalable121710233_scalable
sellable101711823se_llable
semblable1544843semblable
separable1348673separable
stealable1136573stealable
tearable101512673te_arable
teasable101511173te_asable
tellable10169773te_llable
testable101412623tes_table
treatable1139323tre_atable
unsalably1446323unsalably
unsayable1447223unsayable
unscalable1446353unscalable
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.423422437.4
2DLD Change Limit1486411237.78019105.5
3Display Results1231230.0502460.0
 (SQL Overall)1786911238.25321651.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.