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

262 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
equable184925(None) 
equably2136181equably
eatable91717602eatable
educable1337092educable
effable15106672effable
enable83318482e_nable
equal1449822equa_l_
equaled17166922equa_led
equalled1834862equalled
equally1936872equally
equals1538692equa_ls
equatable2045192equatable
equate152012462equa_te
equitable2046192equitable
errable9312182errable
eyeable1239062eyeable
quale143617852_qua_le
squabble2143882squabble
suable83920552_suable
able66340533___able
abubble1044523abubble
abusable1236373abusable
actable11313473actable
addable11218843addable
affable15117403affable
amiable11312033amiable
amusable1237143amusable
aquae142212713aqua__e
arable81821003_arable
arguable1135903arguable
bauble103813213bau_ble
bearable121512363bearable
beatable121612243beatable
beddable14166923beddable
bejumble2172773bejumble
bendable131510853bendable
bitable11312203bitable
bubale104014623_bubale
bubble94016593_bubble
bumble124216893_bumble
burble104617703_burble
buyable1437493buyable
cable95329913__cable
capable13313363capable
causable1239973causable
citable11313463citable
clubable1436093clubable
codable12311663codable
crumble133410403crumble
curable112414513curable
datable101714233datable
deniable11312083deniable
deputable1487043deputable
disable10516433disable
doable93115243_doable
double94013993dou_ble
dowable13189453dowable
drumble12337893drumble
dryable13237433dryable
dupable12238383dupable
durable102312723durable
dyable12308983_dyable
dyeable1337303dyeable
eagle64219483e__agle
eatables10169793eatables
edible969353e_dible
editable11310423editable
educables1443473educables
educible1344433educible
ekuele1034383eku_ele
eluate62315433elua_te
empale102611263empa_le
enabled102510633e_nabled
enabler9299363e_nabler
enables92813123e_nables
endurable1247733endurable
ennoble935633ennoble
enviable1337853enviable
equalise1748213equalise
equalize2648023equalize
equated171910403equated
equates162012323equates
equator1637483equator
equine151711573equ_ine
equitably2344423equitably
erasable10511043erasable
erodable1139203erodable
evadable1436363evadable
evaluable1444233evaluable
evitable1339323evitable
evocable1537103evocable
excusable2044373excusable
exhale1636873exha_le
exilable1737203exilable
exorable1738933exorable
expiable1946113expiable
fable105824753__fable
fadable13310463fadable
feedable1437673feedable
fellable13179133fellable
finable122213623finable
fixable19218193fixable
flyable15307123flyable
friable122612563friable
fryable15277463fryable
fumble133214263_fumble
gable85325523__gable
gelable101710733gelable
getable101712553getable
gettable11178133gettable
grumble12349233grumble
hatable121713963hatable
healable131610173healable
hearable131611603hearable
heatable131612043heatable
helpable1536603helpable
hewable15177823hewable
hidable1399403hidable
hirable121612313hirable
humble133615053_humble
issuable1046873issuable
jumble174012653_jumble
keepable1635323keepable
laudable1137893laudable
leasable101510133leasable
lendable11169463lendable
leviable1337513leviable
liable81415813_liable
likable13219413likable
linable92214343linable
livable122010323livable
losable91910953losable
lovable12179553lovable
makable15510203makable
meltable12310473meltable
mendable131510583mendable
minable112315073minable
mixable18259173mixable
movable14189433movable
mumble123614343_mumble
mutable11312303mutable
namable11312343namable
nestable101613673nestable
nettable101610243nettable
notable92114903notable
nubble103813713_nubble
ownable1237283ownable
parable111819773parable
payable141711323payable
peccable1648123peccable
peelable1238553peelable
perusable1347453perusable
pettable121710713pettable
pliable111610323pliable
pokable15209503pokable
posable112212783posable
potable112115363potable
pourable1239133pourable
prunable1237843prunable
quaere154110673_quaere
quail144314363_quail_
quailed1737823_quailed
quails153412643_quails
quake184114643_qua_ke
qualm163511183_qua_lm
quare143920543_qua_re
quarte154115323_quarte
quate144521413_qua_te
quatre153512353_quatre
quibble2034713_quibble
quotable1936493_quotable
ratable91717553ratable
readable11313163readable
reapable12311393reapable
reefable1339533reefable
reelable10311593reelable
refusable1476683refusable
refutable1477863refutable
regulable1246513regulable
reliable10313073reliable
rentable101716333rentable
reputable1379123reputable
rescuable1347583rescuable
restable101618443restable
resumable1347553resumable
retable91820403retable
reusable10811273reusable
ridable101412493ridable
ropable111611333ropable
rouble83913313rou_ble
rowable121510303rowable
rubble104315673_rubble
ruble74521253_ru_ble
rulable9310533rulable
rumble103718813_rumble
sable74732163__sable
salable91415463salable
savable121711863savable
sayable121411613sayable
scumble1337013scumble
sealable101512693sealable
securable1347773securable
seeable91113943seeable
seisable10311373seisable
seizable1938723seizable
sellable101711823sellable
sendable111612043sendable
servable13310093servable
sewable121911173sewable
sizable1839893sizable
skiable1338883skiable
sowable121610753sowable
squab163810733squab__
squabbled2342563squabbled
squabbler2242733squabbler
squabbles2243633squabbles
squabby2343283squabby
squabs17429323squab_s
squall1538003squa_ll
squalled1835943squalled
squaller1736083squaller
squalls1647313squalls
squally1937673squally
squamae1845723squamae
square154513363squa_re
squatly1946433squatly
stable83921643_stable
stubble1136843stubble
stumble1147553stumble
suably112814533_suably
table75429603__table
takable13310193takable
tamable11312853tamable
taxable1639073taxable
tearable101512673tearable
teasable101511173teasable
tellable10169773tellable
tenable93214493tenable
tenurable1147423tenurable
testable101412623testable
totable92313363totable
towable121910113towable
triable92515393triable
tumble103215643_tumble
tunable92511313tunable
typable1435883typable
unable83819223_unable
unusable1038953unusable
usable84012553_usable
useable9911063useable
usquabae1941893usquabae
valuable1336863valuable
vendable14159693vendable
viable111613773_viable
vocable14189673vocable
votable122111373votable
wadable13310233wadable
waxable1937673waxable
wearable131510553wearable
weldable1436863weldable
wettable13148043wettable
wirable121610963wirable

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 Filter1786911340270.420425454.8
2DLD Change Limit1340272627.30018359.9
3Display Results2622620.0932817.2
 (SQL Overall)1786912627.81322871.0
 
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.