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

114 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
educable133709(None) 
educables1443471educables
educible1344431educible
deducible1543392deducible
dupable12238382_dupable
durable102312722_durable
editable11310422editable
educate10310212educa_te
endurable1247732endurable
equable1849252equ_able
evocable1537102evocable
ineducable1546222ineducable
medicable1647502medicable
reducible1444692reducible
seducible1443352seducible
uneducable1545782uneducable
abdicable1685023abdicable
abusable1236373abusable
addable11218843ad_dable
adducible1542213adducible
adorable1138773adorable
amicable1438433amicable
amusable1237143amusable
beddable14166923bed_dable
buyable1437493_buyable
cable95329913___cable
cascable141510623cascable
causable1239973causable
clubable1436093clubable
crucible1445193crucible
curable112414513_curable
datable101714233_datable
deducibly1842593deducibly
deductible1643203deductible
deniable11312083deniable
deputable1487043deputable
disable10516433_disable
doable93115243_d_oable
dowable13189453_dowable
dryable13237433_dryable
ducal84816423_duca_l_
ducally13257413_ducally
ductile1048483_ductile
ductule1065503_ductule
durables11237013_durables
durably13229053_durably
dutiable1137373_dutiable
dyable12308983_d_yable
dyeable1337303_dyeable
eatable91717603e_atable
edible969353ed__ible
educated1237943educated
educates1139623educates
educative15136553educative
educator1147153educator
educe84313453educ___e
eductive1476863eductive
effable15106673e_ffable
ejectable20136573ejectable
electable13149623electable
enable83318483e__nable
enactable1338493enactable
endurably1545673endurably
enunciable1444313enunciable
enviable1337853enviable
equably2136183equ_ably
equatable2045193equatable
equitable2046193equitable
eradicable1545633eradicable
erasable10511043erasable
erectable131210093erectable
erodable1139203erodable
errable9312183e_rrable
eucaine939243e_ucaine
evadable1436363evadable
evitable1339323evitable
exactable2046433exactable
excusable2044373excusable
execrable2046233execrable
exilable1737203exilable
exorable1738933exorable
expiable1946113expiable
eyeable1239063e_yeable
inducible1446233inducible
judicable2143643judicable
laudable1137893laudable
mutable11312303_mutable
peccable1648123peccable
perdurable1544753perdurable
perusable1347453perusable
placable14169243placable
pourable1239133pourable
predicable1747193predicable
prunable1237843prunable
reducibly1743493reducibly
refusable1476683refusable
refutable1477863refutable
regulable1246513regulable
reputable1379123reputable
rescuable1347583rescuable
resumable1347553resumable
reusable10811273reusable
revocable1647003revocable
rulable9310533_rulable
securable1347773securable
suable83920553_su_able
tenurable1147423tenurable
touchable1645023touchable
truckable1744513truckable
tunable92511313_tunable
unable83819223__unable
unusable1038953unusable
usable84012553__usable
vocable14189673_vocable

Search took 10 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.406440125.6
2DLD Change Limit1461621148.73316736.7
3Display Results1141140.0462478.3
 (SQL Overall)1786911149.18519454.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.