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

236 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
wastable13141045(None) 
castable121613971castable
tastable101511971tastable
washable16138041washable
actable11313472_actable
cartable121314092cartable
cascable141510622cascable
cashable15159792cashable
datable101714232da_table
eatable91717602ea_table
gustable11138202gustable
hatable121713962ha_table
instable10313192instable
listable10810302listable
maskable1638002maskable
nestable101613672nestable
passable12310622passable
ratable91717552ra_table
restable101618432restable
rustable101511352rustable
stable83921642__stable
tasteable1146122tasteable
testable101412622testable
twistable1444272twistable
unstable10313762unstable
wadable13310232wa_dable
wadeable1437442wadeable
walkable1736062walkable
washables17144742washables
wastage11109252wasta_ge
waxable1937672wa_xable
wettable13148042wettable
writable1338752writable
abatable1238023abatable
adaptable1444613adaptable
addable11218843_addable
affable15117403_affable
agitable1138583agitable
amassable1346063amassable
amiable11312033_amiable
arable81821003_a_rable
astilbe945653_astilbe
awardable1543953awardable
bailable1238583bailable
bankable1677913bankable
bannable1278353bannable
barrable1249243barrable
bastile9313913bast_ile
bastille1047993bastille
beatable121612243beatable
bitable11312203_bitable
boatable121610263boatable
bootable12179223bootable
callable12310753callable
cantabile1346893cantabile
capable13313363ca_pable
cascabel14174503cascabel
cascables15165773cascables
castle84918963cast__le
causable1239973causable
chantable1636893chantable
chartable1636833chartable
chaseable1646343chaseable
citable11313463_citable
classable1347143classable
constable13310993constable
cuttable1247953cuttable
damnable1347593damnable
dateable1149443dateable
disable10516433dis_able
draftable1575563draftable
eatables10169793ea_tables
editable11310423editable
enactable1338493enactable
erasable10511043eras_able
evitable1339323evitable
exactable2046433exactable
faceable15108493faceable
fadable13310463fa_dable
farmable1538203farmable
fastball1344913fastball
fishable1637593fishable
fittable1337083fittable
gainable1138933gainable
getable101712553_getable
gettable11178133gettable
giftable1465893giftable
grantable1257293grantable
graspable1444873graspable
gustables12165223gustables
habitable1645953habitable
hackable1937473hackable
hangable1438203hangable
hastate10313913hasta_te
hateable1339373hateable
heatable131612043heatable
hittable1336843hittable
huntable1338093huntable
imitable1239123imitable
issuable1046873issuable
jailable1737143jailable
jammable2144513jammable
kissable1436853kissable
lapsable12117383lapsable
laudable1137893laudable
leasable101510133leas_able
liftable1376863liftable
losable91910953los_able
mailable1239623mailable
makable15510203ma_kable
makeable1637253makeable
mappable1635923mappable
mastaba1146223mastab_a
mastabah1554023mastabah
mastabas1246803mastabas
meltable12310473meltable
metastable1444923metastable
missable12311533missable
mutable11312303_mutable
namable11312333na_mable
nameable1238863nameable
nettable101610243nettable
notable92114903_notable
obstacle1243593obstacle
packable1838633packable
paintable1337243paintable
palatable1346373palatable
palpable1448033palpable
parable111819773pa_rable
parsable12311693parsable
partible1238063partible
passably1537253passably
passible1237683passible
pastille1038943pastille
pawnable1535983pawnable
payable141711323pa_yable
pettable121710713pettable
plantable1337273plantable
portable12313203portable
posable112212783pos_able
potable112115363_potable
quotable1936493quotable
radiable11611303radiable
raisable10311643raisable
raiseable1147233raiseable
ratables10159723ra_tables
ratably121711513ra_tably
rateable10311443rateable
rentable101716333rentable
restabled12148943restabled
restables111511423restables
retable91820403_retable
sable74732163__s_able
sailable10310563sailable
salable91415463sa_lable
saleable10312023saleable
salvable1338403salvable
sandable111612823sandable
satiable10310733satiable
savable121711863sa_vable
saveable1339003saveable
sayable121411613sa_yable
sortable10312483sortable
stabile9312063__stabile
stabled103514953__stabled
stabler94014933__stabler
stables93219073__stables
stably113314123__stably
stale55637103__sta_le
staple84415823__staple
statable10310703statable
suable83920553__suable
suitable10310893suitable
swayable16135533swa_yable
table75429603___table
takable13310193ta_kable
takeable1437463takeable
talkable1437193talkable
tamable11312843ta_mable
tameable1238603tameable
tannable1039383tannable
tapeable1238823tapeable
tappable1436343tappable
taxable1639073ta_xable
teasable101511173teas_able
tiltable10159013tiltable
totable92313363_totable
tractable1338513tractable
trustable1147123trustable
unactable13310053unactable
unstabler1145623unstabler
unstably1339493unstably
usable84012553_us_able
useable9911063_useable
vacatable1644643vacatable
valuable1336863valuable
variable13310063variable
visitable1445863visitable
votable122111373_votable
wabble133714843wa__bble
waftage14115323wafta_ge
wagtail1145043wagtail_
wagtails1244443wagtails
wamble134415753wa__mble
wannabe1234533wannab_e
wannabee1343993wannabee
wantage11119623wanta_ge
warble113516603wa__rble
warstle10328013warst__le
wasabi1154643was_ab_i
wasabis1255363was_abis
wassail1056133wassail_
wassailed1343153wassailed
wassailer1242783wassailer
wassails1145953wassails
wastages12109753wastages
waste86125053wast___e
wasterie111211583wasterie
wastrel1037553wastrel_
wastrels1136203wastrels
wastrie101210293wast_rie
watape11208483wa_ta_pe
watchable1944773watchable
wattage1186983watta_ge
wattape12135383watta_pe
wattle94314213wa_t_tle
wearable131510553wearable
weldable1436863weldable
willable13168683willable
windable14159153windable
winnable13156983winnable
wirable121610963w_irable
workable1737093workable
worktable1844723worktable
wrastle10368993wrast__le
writeable1444613writeable

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.1561145455.1
2DLD Change Limit1461622369.28315745.1
3Display Results2362360.0932537.6
 (SQL Overall)1786912369.53218746.4
 
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.