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

203 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
effable1510667(None) 
affable15117401affable
affably1855182affably
buffable1844392buffable
eatable91717602eatable
efface14366672effa_ce
enable83318482e_nable
equable1849252equable
errable9312182errable
eyeable1239062eyeable
fable105824752__fable
ineffable17105792ineffable
reefable1339532reefable
able66340533___able
actable11313473actable
addable11218843addable
affaire1344463affaire
affixable2443343affixable
amiable11312033amiable
arable81821003_arable
bearable121512363bearable
beatable121612243beatable
beddable14166923beddable
bendable131510853bendable
bitable11312203bitable
bluffable1942063bluffable
buyable1437493buyable
cable95329913__cable
capable13313363capable
citable11313463citable
codable12311663codable
curable112414513curable
datable101714233datable
definable1547773definable
deniable11312083deniable
disable10516433disable
doable93115243_doable
dowable13189453dowable
dryable13237433dryable
dupable12238383dupable
durable102312723durable
dyable12308983_dyable
dyeable1337303dyeable
eagle64219483e__agle
eatables10169793eatables
edible969353e_dible
editable11310423editable
educable1337083educable
effaceable2042263effaceable
effaced16225573effaced
effacer15255413effacer
effaces15277273effaces
effete1235183eff_ete
effulge1442473effulge
effuse1234963eff_use
empale102611263empa_le
enabled102510633e_nabled
enabler9299363e_nabler
enables92813123e_nables
enface112510353enfa_ce
enfeeble13103223enfeeble
ennoble935633ennoble
enviable1337853enviable
equably2136183equably
erasable10511043erasable
erodable1139203erodable
evadable1436363evadable
evitable1339323evitable
evocable1537103evocable
exhale1636873exha_le
exilable1737203exilable
exorable1738933exorable
expiable1946113expiable
fabled124216383__fabled
fabler116115813__fabler
fables114921673__fables
fadable13310463fadable
farle86929243__farle
feeble1138253_feeble
feedable1437673feedable
fellable13179133fellable
female11310553fema_le
fenagle11197153fenagle
fimble133611753_fimble
finable122213623finable
fixable19218193fixable
flyable15307123flyable
foible11410383_foible
friable122612563friable
fryable15277463fryable
fumble133214263_fumble
gable85325523__gable
gelable101710733gelable
getable101712553getable
gettable11178133gettable
giftable1465893giftable
hatable121713963hatable
healable131610173healable
hearable131611603hearable
heatable131612043heatable
helpable1536603helpable
hewable15177823hewable
hidable1399403hidable
hirable121612313hirable
ineffably20104623ineffably
keepable1635323keepable
leasable101510133leasable
lendable11169463lendable
leviable1337513leviable
liable81415813_liable
liftable1376863liftable
likable13219413likable
linable92214343linable
livable122010323livable
losable91910953losable
lovable12179553lovable
makable15510203makable
meltable12310473meltable
mendable131510583mendable
minable112315073minable
mixable18259173mixable
movable14189433movable
mutable11312303mutable
namable11312333namable
nestable101613673nestable
nettable101610243nettable
notable92114903notable
offal1136243offa_l_
offals1235893offa_ls
outfable1378813outfable
ownable1237283ownable
parable111819773parable
payable141711323payable
peccable1648103peccable
peelable1238553peelable
pettable121710713pettable
pliable111610323pliable
pokable15209503pokable
posable112212783posable
potable112115363potable
ratable91717553ratable
readable11313163readable
reapable12311393reapable
reelable10311593reelable
referable1439623referable
refinable1438623refinable
refusable1476683refusable
refutable1477863refutable
reliable10313073reliable
rentable101716333rentable
restable101618433restable
retable91820403retable
reusable10811273reusable
ridable101412493ridable
ropable111611333ropable
rowable121510303rowable
rulable9310533rulable
sable74732163__sable
salable91415463salable
savable121711863savable
sayable121411613sayable
sealable101512693sealable
seeable91113943seeable
seisable10311373seisable
seizable1938723seizable
sellable101711823sellable
sendable111612043sendable
servable13310083servable
sewable121911173sewable
sizable1839893sizable
skiable1338883skiable
sniffable1743773sniffable
sowable121610753sowable
stable83921643_stable
suable83920553_suable
surfable1338443surfable
table75429603__table
takable13310193takable
tamable11312843tamable
taxable1639073taxable
tearable101512673tearable
teasable101511173teasable
tellable10169773tellable
tenable93214493tenable
testable101412623testable
totable92313363totable
towable121910113towable
triable92515393triable
tunable92511313tunable
typable1435883typable
unable83819223_unable
usable84012553_usable
useable9911063useable
vendable14159693vendable
viable111613773_viable
vocable14189673vocable
votable122111373votable
wadable13310233wadable
waxable1937673waxable
wearable131510553wearable
weldable1436863weldable
wettable13148043wettable
wirable121610963wirable

Search took 7 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 Filter1786911340270.1561145455.1
2DLD Change Limit1340272036.31021240.4
3Display Results2032030.0802537.5
 (SQL Overall)1786912036.54627297.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.