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

135 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
dippable153612(None) 
rippable1435381rippable
tippable1435261tippable
chippable2073352chippable
clippable1773462clippable
dimmable1536112dimmable
disable10516432di_sable
drapable1377572drapable
droppable1643272droppable
dupable12238382d_upable
mappable1635922mappable
shippable1853792shippable
skippable1952582skippable
tappable1436342tappable
adaptable1444613adaptable
adoptable1444753adoptable
biddable14165673biddable
billable12179503billable
bindable13169623bindable
bitable11312203bi_table
biteable1237933biteable
capable13313363_capable
citable11313463ci_table
citeable1238413citeable
copyable1736623copyable
culpable1436283culpable
damnable1347593damnable
dapple1138853dapp__le
datable101714233d_atable
dateable1149443dateable
deniable11312083deniable
deposable1446833deposable
deputable1487043deputable
diapause1143893diapause
dibble114013843di__bble
dilatable1246853dilatable
dimple113512793dimp__le
diphase1387273dipha_se
dipole91112853di_p_ole
disabled1248713di_sabled
disabler1147913di_sabler
disables11410903di_sables
disenable1249673disenable
disposable1545873disposable
disputable1545063disputable
dividable1645003dividable
doable93115243d__oable
dowable13189453d_owable
drapeable1445673drapeable
drawable1467113drawable
drillable1245133drillable
drinkable1644113drinkable
drivable1438023drivable
driveable1544523driveable
dryable13237433d_ryable
durable102312723d_urable
dutiable1137373dutiable
dyable12308983d__yable
dyeable1337303d_yeable
editable11310423edi_table
expiable1946113expiable
fileable13179223fileable
fillable13179573fillable
filmable15157133filmable
finable122213623fi_nable
findable14179023findable
fineable131810333fineable
fipple13329063fipp__le
fireable131710223fireable
fishable1637593fishable
fittable1337093fittable
fixable19218193fi_xable
flappable1843563flappable
giftable1465893giftable
giveable14155753giveable
helpable1536603helpable
hidable1399403hi_dable
hirable121612313hi_rable
hireable13139083hireable
hittable1336853hittable
impale102811663_impa_le
jumpable2143953jumpable
keepable1635323keepable
kickable1535583kickable
killable14168133killable
kissable1436853kissable
lapsable12117383lapsable
liable81415813li__able
lienable10188693lienable
liftable1376863liftable
likable13219413li_kable
likeable14166473likeable
linable92214343li_nable
lineable101811083lineable
linkable14187263linkable
listable10810313listable
livable122010323li_vable
liveable13177663liveable
millable121710133millable
minable112315073mi_nable
mineable121611053mineable
missable12311533missable
mixable18259173mi_xable
nipple103410373nipp__le
palpable1448033palpable
pitiable1238293pitiable
reapable12311393reapable
ridable101412493ri_dable
rideable1158653rideable
rinsable10310043rinsable
ripple103413913ripp__le
ropable111611333_ropable
shapable15197803shapable
singable11159543singable
sinkable14178413sinkable
sizable1839893si_zable
sizeable1937113sizeable
stoppable1544103stoppable
strippable1642663strippable
tapeable1238823tapeable
tillable10159753tillable
tiltable10159013tiltable
tipple103411913tipp__le
tithable1336853tithable
titrable1038963titrable
typable1435883_typable
typeable1535233typeable
viable111613773vi__able
viewable1635223viewable
violable1337543violable
vitiable1337503vitiable
willable13168683willable
windable14159153windable
winnable13156983winnable
wirable121610963wi_rable

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.453394461.4
2DLD Change Limit1461621356.42322756.0
3Display Results1351350.0761776.3
 (SQL Overall)1786911356.95225703.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.