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

155 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
beddable1416692(None) 
bendable131510851bendable
biddable14165671biddable
addable11218842_addable
bearable121512362bearable
beatable121612242beatable
bedabble1243702bedabble
biddably17173542biddably
bindable13169622bindable
bondable13169272bondable
feedable1437672feedable
lendable11169462lendable
mendable131510582mendable
readable11313162readable
sendable111612042sendable
sheddable1643692sheddable
vendable14159692vendable
weldable1436862weldable
abradable1495063abradable
addible11236063_addible
amendable1446053amendable
bailable1238583bailable
bankable1677913bankable
bannable1278353bannable
barrable1249243barrable
beadle93314683be__adle
beagle93612593be__agle
bearably15177933bearably
bedabbled1442543bedabbled
bedabbles1343043bedabbles
bedazzle1942143bedazzle
bedimple1543133bedimple
bedmate1239433bedma_te
bedraggle1442123bedraggle
bedrail1037253bedrail_
bedrails1136293bedrails
bedrape1277693bedra_pe
bejumble2172773bejumble
beldame1237233belda_me
berdache1644033berdache
billable12179503billable
bitable11312203b_itable
biteable1237933biteable
blamable1436693blamable
boardable1444893boardable
boatable121610263boatable
boilable1237793boilable
bombable1336263bombable
bookable16127003bookable
bootable12179223bootable
boundable1444843boundable
breakable1746163breakable
bribable1137223bribable
buddle104313083budd__le
buffable1844393buffable
buildable1443523buildable
burnable1237263burnable
buyable1437493b_uyable
codable12311663_codable
decidable1547223decidable
deniable11312083deniable
doable93115243__doable
dyable12308983__dyable
eatable91717603_eatable
edible969353_e_dible
editable11310423_editable
educable1337093_educable
effable15106673_effable
emendable1446233emendable
enable83318483_e_nable
equable1849253_equable
erodable1139203erodable
errable9312183_errable
evadable1436363evadable
eyeable1239063_eyeable
fadable13310463_fadable
fellable13179133fellable
findable14179023findable
foldable1437133foldable
fordable1439593fordable
gelable101710733ge_lable
getable101712553ge_table
gettable11178133gettable
gradable1238823gradable
guidable1236203guidable
healable131610173healable
hearable131611603hearable
heatable131612043heatable
heddle114211163hedd__le
helpable1536603helpable
hewable15177823he_wable
hidable1399403_hidable
holdable1437073holdable
keepable1635323keepable
kneadable1645673kneadable
laudable1137893laudable
leasable101510133leasable
leviable1337513leviable
meddle103312763medd__le
medicable1647503medicable
meltable12310473meltable
moldable1337103moldable
nestable101613673nestable
nettable101610243nettable
obeyable1544113obe_yable
oxidable1865123oxidable
peccable1648123peccable
peddle103512823pedd__le
peelable1238553peelable
pettable121710713pettable
pleadable1445513pleadable
radiable11611303radiable
readably1438383readably
reapable12311393reapable
reddle83815913redd__le
redouble1145523redouble
reefable1339533reefable
reelable10311593reelable
reliable10313073reliable
rendible11128353rendible
rentable101716333rentable
restable101618443restable
retable91820403re_table
reusable10811273reusable
ridable101412493_ridable
rideable1158653rideable
sandable111612823sandable
sealable101512693sealable
seeable91113943se_eable
seisable10311373seisable
seizable1938723seizable
sellable101711823sellable
servable13310083servable
sewable121911173se_wable
shedable1437423shedable
slidable1137953slidable
spendable1446463spendable
tearable101512673tearable
teasable101511173teasable
tellable10169773tellable
tenable93214493te_nable
testable101412623testable
tradable1139873tradable
unbendable1545813unbendable
undoable1139053undoable
vendables15165153vendables
vendible14156473vendible
voidable1466853voidable
wadable13310233_wadable
wadeable1437443wadeable
wearable131510553wearable
wettable13148043wettable
wieldable1543813wieldable
windable14159153windable
yieldable1543353yieldable

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.420425454.8
2DLD Change Limit1461621557.09620597.8
3Display Results1551550.0602583.3
 (SQL Overall)1786911557.57623586.5
 
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.