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

139 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
exilable173720(None) 
bailable1238582bailable
boilable1237792boilable
editable11310422editable
evitable1339322evitable
excisable2045052excisable
excitable2056242excitable
exigible18113682exigible
exorable1738932exorable
expiable1946112expiable
foilable1338062foilable
jailable1737142jailable
mailable1239622mailable
oxidable1865122oxidable
sailable10310562sailable
agitable1138583agitable
alliable1038433alliable
amiable11312033ami_able
amicable1438433amicable
available1444903available
billable12179503billable
bitable11312203_bitable
bribable1137223bribable
buildable1443523buildable
callable12310753callable
citable11313463_citable
coinable12311583coinable
decidable1547223decidable
definable1547773definable
demisable1448533demisable
deniable11312083deni_able
derivable1548063derivable
desirable1249393desirable
devisable1546853devisable
disable10516433_disable
drillable1245133drillable
drivable1438023drivable
eatable91717603e_atable
edible969353edi__ble
educable1337093educable
effable15106673e_ffable
elidible1164573elidible
eligible11114693eligible
enable83318483e__nable
enviable1337853enviable
epilate9314283epila_te
equable1849253e_quable
equitable2046193equitable
erasable10511043erasable
erodable1139203erodable
errable9312183e_rrable
estimable1346043estimable
evadable1436363evadable
evaluable1444233evaluable
evocable1537103evocable
evolvable1743383evolvable
exactable2046433exactable
examinable2144093examinable
excitably2364493excitably
exclave1945193excla_ve
excludable2252543excludable
excusable2044373excusable
execrable2046233execrable
exhale1636873ex_ha_le
exile126117653exi___le
expellable2143213expellable
explicable2344343explicable
exposable2044793exposable
extricable2144743extricable
eyeable1239063e_yeable
fellable13179133fellable
fileable13179223_fileable
fillable13179573fillable
filmable15157133_filmable
finable122213623_finable
fixable19218193_fixable
friable122612563fri_able
furlable1335893furlable
gainable1138933gainable
gelable101710733_gelable
guidable1236203guidable
gullable1136463gullable
healable131610173healable
heritable1439453heritable
hidable1399403_hidable
hirable121612313_hirable
imitable1239123imitable
isolable1038793isolable
joinable1737283joinable
killable14168133killable
leviable1337513levi_able
liable81415813_li_able
likable13219413_likable
linable92214343_linable
livable122010323_livable
medicable1647503medicable
millable121710133millable
minable112315073_minable
mixable18259173_mixable
peelable1238553peelable
pliable111610323pli_able
raisable10311643raisable
reelable10311593reelable
refillable1544073refillable
refinable1438623refinable
regulable1246513regulable
reliable10313073reli_able
relivable1438513relivable
resalable1138733resalable
revisable1437993revisable
revivable1736863revivable
ridable101412493_ridable
ruinable1039263ruinable
rulable9310533_rulable
salable91415463_salable
scalable121710233scalable
sealable101512693sealable
seisable10311373seisable
seizable1938723seizable
sellable101711823sellable
semblable1544843semblable
sizable1839893_sizable
skiable1338883ski_able
slidable1137953slidable
spillable1345353spillable
spoilable1345163spoilable
suitable10310893suitable
syllable13177773syllable
tellable10169773tellable
tillable10159753tillable
tiltable10159013_tiltable
triable92515393tri_able
veritable1448743veritable
viable111613773_vi_able
violable1337543violable
voidable1466853voidable
willable13168683willable
wirable121610963_wirable
writable1338753writable

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 Filter1786911461620.423422437.4
2DLD Change Limit1461621397.06320694.0
3Display Results1391390.0463021.7
 (SQL Overall)1786911397.53223724.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.