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 “mixable” 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
mixable1825917(None) 
fixable19218191fixable
minable112315071minable
mixible18195091mixible
amiable11312032ami_able
amicable1438432amicable
bitable11312202bitable
citable11313462citable
disable10516432disable
finable122213622finable
hidable1399402hidable
hirable121612312hirable
imitable1239122imitable
liable81415812li_able
likable13219412likable
linable92214342linable
livable122010322livable
mailable1239622mailable
makable15510202makable
millable121710132millable
mineable121611052mineable
miracle1138842miracle
missable12311532missable
movable14189432movable
mutable11312302mutable
ridable101412492ridable
sizable1839892sizable
taxable1639072taxable
unmixable2045862unmixable
viable111613772vi_able
waxable1937672waxable
wirable121610962wirable
able66340533___able
actable11313473actable
addable11218843addable
admirable1445433admirable
affable15117403affable
affixable2443343affixable
agitable1138583agitable
amenable1238863amenable
amiably1438303ami_ably
amicably1746333amicably
amusable1237143amusable
arable81821003_arable
bailable1238583bailable
bible95119423bi__ble
biddable14165673biddable
billable12179503billable
bindable13169623bindable
biteable1237933biteable
boilable1237793boilable
bribable1137223bribable
buyable1437493buyable
cable95329913__cable
capable13313363capable
cicale10314503cica_le
citeable1238413citeable
codable12311663codable
coinable12311583coinable
curable112414513curable
datable101714233datable
demisable1448533demisable
dibble114013843di_bble
dimmable1536113dimmable
dippable1536123dippable
disabled1248713disabled
disabler1147913disabler
disables11410903disables
doable93115243_doable
dowable13189453dowable
drivable1438023drivable
dryable13237433dryable
dupable12238383dupable
durable102312723durable
dyable12308983_dyable
dyeable1337303dyeable
eatable91717603eatable
editable11310423editable
effable15106673effable
enable83318483_enable
equable1849253equable
errable9312183errable
evitable1339323evitable
exilable1737203exilable
eyeable1239063eyeable
fable105824753__fable
fadable13310463fadable
fileable13179223fileable
fillable13179573fillable
filmable15157133filmable
fimble133611753fi_mble
finagle11238313finagle
finale94116763fina_le
findable14179023findable
fineable131810333fineable
fireable131710223fireable
fishable1637593fishable
fittable1337093fittable
fixate1638733fixa_te
flyable15307123flyable
foilable1338063foilable
friable122612563friable
fryable15277463fryable
gable85325523__gable
gainable1138933gainable
gelable101710733gelable
getable101712553getable
giftable1465893giftable
giveable14155753giveable
guidable1236203guidable
hatable121713963hatable
hewable15177823hewable
hireable13139083hireable
hittable1336853hittable
impale102811663impa_le
ixtle12168013_ix_tle
jailable1737143jailable
joinable1737283joinable
kibble143910953ki_bble
kickable1535583kickable
killable14168133killable
kissable1436853kissable
laminable1337123laminable
lienable10188693lienable
liftable1376863liftable
likeable14166473likeable
limitable1345643limitable
lineable101811083lineable
linkable14187263linkable
listable10810313listable
liveable13177663liveable
losable91910953losable
lovable12179553lovable
mabe85733363m__ab_e
macabre1335223macabre
macle96127003m__acle
maile75232223m__aile
makeable1637253makeable
male66052303m__a_le
manacle11310283manacle
maple95521143m__aple
mappable1635923mappable
marble104219103m_arble
maskable1638003maskable
measle83513223m_easle
medicable1647503medicable
meltable12310473meltable
mendable131510583mendable
miaul71612123mi_aul_
miauled1036663mi_auled
miauls8178713mi_auls
micelle1178343micelle
mickle143715133mi_ckle
middle103414983mi_ddle
midsole1037813midsole
miggle104012113mi_ggle
milage93414123mila_ge
mile66352573mi___le
mille75029133mi__lle
minae75627723mina__e
mingle93518783mi_ngle
mirabelle1343333mirabelle
miracles1238333miracles
mirage92313653mira_ge
misally121111063misally
misate81222693misa_te
miscible1447673miscible
miserable1349653miserable
misfile122611553misfile
mislabel1296173mislabel
misrule939353misrule
missile92815403missile
mitigable1444753mitigable
mixedly2033983mixedly
mixture1635413mixture
mizzle16279993mi_zzle
mockable1846643mockable
moldable1337103moldable
morale85220553mora_le
movables15175573movables
movably17167043movably
moveable15168013moveable
mumble123614343m_umble
mutably1438613mutably
namable11312343namable
nibble103713283ni_bble
nimble103412943ni_mble
notable92114903notable
ownable1237283ownable
oxidable1865123oxidable
parable111819773parable
payable141711323payable
pitiable1238293pitiable
pliable111610323pliable
pokable15209503pokable
posable112212783posable
potable112115363potable
raisable10311643raisable
ratable91717553ratable
retable91820403retable
rideable1158653rideable
rinsable10310043rinsable
rippable1435383rippable
risible937923risible
ropable111611333ropable
rowable121510303rowable
ruinable1039263ruinable
rulable9310533rulable
sable74732163__sable
sailable10310563sailable
salable91415463salable
savable121711863savable
sayable121411613sayable
seeable91113943seeable
seisable10311373seisable
seizable1938723seizable
sewable121911173sewable
singable11159543singable
sinkable14178413sinkable
sizably2136613sizably
sizeable1937113sizeable
skiable1338883skiable
slidable1137953slidable
smokable1636223smokable
sowable121610753sowable
stable83921643_stable
suable83920553_suable
suitable10310893suitable
table75429603__table
takable13310193takable
tamable11312853tamable
taxables1734383taxables
taxably1936043taxably
tenable93214493tenable
tillable10159753tillable
tiltable10159013tiltable
timbale11248803timbale
tippable1435263tippable
tithable1336853tithable
titrable1038963titrable
totable92313363totable
towable121910113towable
triable92515393triable
tunable92511313tunable
typable1435883typable
unable83819223_unable
usable84012553_usable
useable9911063useable
viably14199833vi_ably
viewable1635223viewable
violable1337543violable
visible1236923visible
vitiable1337503vitiable
vocable14189673vocable
voidable1466853voidable
votable122111373votable
wadable13310233wadable
willable13168683willable
wimble133211923wi_mble
windable14159153windable
winnable13156983winnable
writable1338753writable

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.08018930.4
3Display Results2622620.0932817.2
 (SQL Overall)1786912627.59323533.6
 
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.