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

174 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
wadeable143744(None) 
wadable13310231wad_able
addable11218842_addable
dateable1149442dateable
faceable15108492faceable
fadable13310462fad_able
hateable1339372hateable
makeable1637252makeable
nameable1238862nameable
radiable11611302radiable
rateable10311442rateable
rideable1158652rideable
saleable10312022saleable
saveable1339002saveable
takeable1437462takeable
tameable1238602tameable
tapeable1238822tapeable
tradeable1247412tradeable
walkable1736062walkable
washable16138042washable
wastable131410452wastable
waxable1937672wa_xable
actable11313473_actable
addible11236063_addible
adherable1545003_adherable
adorable1138773_adorable
affable15117403_affable
amenable1238863_amenable
amiable11312033_amiable
arable81821003_a_rable
awardable1543953awardable
bailable1238583bailable
bankable1677913bankable
bannable1278353bannable
barrable1249243barrable
beddable14166923beddable
biddable14165673biddable
biteable1237933biteable
blameable1544723blameable
cadelle1039923cade_lle
callable12310753callable
canoeable1347103canoeable
capable13313363ca_pable
cartable121314093cartable
cascable141510623cascable
cashable15159793cashable
castable121613973castable
causable1239973causable
chaseable1646343chaseable
citeable1238413citeable
codable12311663cod_able
damnable1347593damnable
danceable1445303danceable
datable101714233da_table
doable93115243__doable
drapeable1445673drapeable
dyable12308983__dyable
dyeable1337303_dyeable
eatable91717603ea_table
evadable1436363evad_able
eyeable1239063_eyeable
farmable1538203farmable
feedable1437673feedable
fileable13179223fileable
fineable131810333fineable
fireable131710223fireable
frameable1645353frameable
gainable1138933gainable
gaugeable1342983gaugeable
giveable14155753giveable
gradable1238823grad_able
grazeable2144153grazeable
hackable1937473hackable
handleable1643743handleable
hangable1438213hangable
hatable121713963ha_table
hidable1399403hid_able
hireable13139083hireable
imageable1445443imageable
indexable1947033indexable
jailable1737143jailable
jammable2144513jammable
labelable1344393labelable
lacerable1346943lacerable
lapsable12117383lapsable
laudable1137893laudable
likeable14166473likeable
lineable101811083lineable
liveable13177663liveable
loveable13187903loveable
mailable1239623mailable
makable15510203ma_kable
malleable1376073malleable
mappable1635923mappable
maskable1638003maskable
mineable121611053mineable
moveable15168013moveable
namable11312343na_mable
orderable1246183orderable
packable1838633packable
palpable1448033palpable
parable111819773pa_rable
parsable12311693parsable
passable12310633passable
pawnable1535983pawnable
payable141711323pa_yable
peaceable1548253peaceable
placeable1536913placeable
radiale83813523radia_le
raisable10311643raisable
raiseable1147243raiseable
ratable91717553ra_table
rateably1337783rateably
readable11313163read_able
ridable101412493rid_able
sailable10310563sailable
salable91415463sa_lable
saleably1338213saleably
salvable1338403salvable
sandable111612823sandable
satiable10310733satiable
savable121711863sa_vable
sayable121411613sa_yable
seeable91113943_seeable
shakeable1844943shakeable
shameable1645573shameable
shapeable1645743shapeable
shareable1436733shareable
shedable1437423shedable
sizeable1937113sizeable
spareable1337263spareable
stageable1246343stageable
stateable1136903stateable
swayable16135533swa_yable
takable13310193ta_kable
talkable1437193talkable
tamable11312853ta_mable
tannable1039383tannable
tappable1436343tappable
tastable101511973tastable
tasteable1146123tasteable
taxable1639073ta_xable
toteable1048353toteable
traceable1338323traceable
tradable1139873trad_able
tuneable1038913tuneable
typeable1535233typeable
undoable1139053undoable
useable9911063_useable
valuable1336863valuable
variable13310063variable
voteable1347213voteable
wabble133714843wa__bble
waddle114715303wad__dle
wadmaal1343203wadmaal_
wadmaals1442413wadmaals
wadmal1237283wadma_l_
wadmals1335513wadma_ls
wamble134415753wa__mble
wannabe1234533wannab_e
wannabee1343993wannabee
warble113516603wa__rble
washables17144743washables
watchable1944773watchable
wearable131510553wearable
weldable1436863weldable
wettable13148043wettable
willable13168683willable
windable14159153windable
winnable13156983winnable
wirable121610963w_irable
workable1737093workable
writable1338753writable
writeable1444613writeable

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 Filter1786911461620.420425454.8
2DLD Change Limit1461621746.47022590.7
3Display Results1741740.0802175.0
 (SQL Overall)1786911746.97025637.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.