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

303 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
cartable12131409(None) 
castable121613971castable
chartable1636831chartable
actable11313472_actable
arable81821002_ar_able
barrable1249242barrable
callable12310752callable
cantabile1346892cantabile
capable13313362ca_pable
carpale113414352carpa_le
cartage10312592carta_ge
cascable141510622cascable
cashable15159792cashable
causable1239972causable
chantable1636892chantable
charitable1744642charitable
citable11313462c_itable
curable112414512cur_able
curbable1447662curbable
cuttable1247952cuttable
datable101714232da_table
eatable91717602ea_table
farmable1538202farmable
hatable121713962ha_table
parable111819772par_able
parsable12311692parsable
partible1238062partible
portable12313202portable
ratable91717552ra_table
sortable10312482sortable
tastable101511972tastable
variable13310062variable
wastable131410452wastable
abatable1238023abatable
accruable1543603accruable
adaptable1444613adaptable
addable11218843_addable
affable15117403_affable
agitable1138583agitable
alarmable1345013alarmable
amiable11312033_amiable
arables91814973_ar_ables
arguable1135903_arguable
artal55525473_arta_l_
article9310923_article
avertable14117343avertable
awardable1543953awardable
bailable1238583bailable
bankable1677913bankable
bannable1278353bannable
barnacle1245943barnacle
bearable121512363bear_able
beatable121612243beatable
bitable11312203_bitable
boardable1444893boardable
boatable121610263boatable
bootable12179223bootable
burnable1237263burnable
cable95329913c___able
canoeable1347103canoeable
cantabiles1445763cantabiles
cantal84122033canta_l_
cantala94114673canta_la
cantals93919573canta_ls
canticle1239703canticle
cantle84522153cant__le
capabler1435353ca_pabler
capably1639253ca_pably
carabao1139673car_abao
carabid12311333car_abid
carabin11313213car_abin
carabine12412393car_abine
caracole12310353caracole
carafe115416163car_a_fe
caramel11310253car_amel
carate84734003car_a_te
caravel1238213car_avel
carbazole2243773carbazole
carcase11312743carca_se
caretake1446773careta_ke
carfare12310073carfa_re
caribe103416753car_ib_e
cariole9818343car_iole
carle74535703car___le
carnage10311743carna_ge
carnal83919203carna_l_
carnally1339513carnally
carpal103716253carpa_l_
carpals113414623carpa_ls
carriole1089863carriole
cartages11313313cartages
carte75940423cart___e
cartel85022533cart_el_
cartels94618123cart_els
caruncle1244713caruncle
cascabel14174503cascabel
cascables15165773cascables
castle84918963cast__le
catalo8314853ca_ta_lo
catchable1845713catchable
cattail939183cattail_
cattails1038553cattails
cattalo938423catta_lo
cattle85118903ca_t_tle
chargeable1843473chargeable
charitably2043463charitably
chaseable1646343chaseable
cheatable1646713cheatable
chewable1835443chewable
citeable1238413citeable
claimable1545703claimable
classable1347143classable
clearable1346013clear_able
closable12168003closable
clubable1436093clubable
coachable1846303coachable
codable12311663c_odable
cogitable1446943cogitable
coinable12311583coinable
constable13311003constable
cookable16147973cookable
copyable1736623copyable
coracle112011723cor_acle
countable1348853countable
covetable1648163covetable
cradle93313163c_r_adle
creatable1339563creatable
crumble133410403c_rumble
culpable1436283culpable
curably142010773cur_ably
curtail9299663curtail_
curtailed1244113curtailed
curtailer1143823curtailer
curtails10318243curtails
curtal83914543curta_l_
curtals93111623curta_ls
curtate9312643curta_te
damnable1347593damnable
dartle73714833dart__le
dateable1149443dateable
draftable1575563draftable
drapable1377573drapable
drawable1467113drawable
dryable13237433_dryable
durable102312723dur_able
eatables10169793ea_tables
editable11310423editable
enactable1338493enactable
erasable10511043erasable
errable9312183_errable
evitable1339323evitable
exactable2046433exactable
faceable15108493faceable
fadable13310463fa_dable
farfalle1445063farfalle
fireable131710223fireable
fittable1337093fittable
fordable1439593fordable
formable1539503formable
framable1537573framable
friable122612563_friable
fryable15277463_fryable
furlable1335893furlable
gainable1138933gainable
garble94118453gar__ble
getable101712553_getable
gettable11178133gettable
giftable1465893giftable
gradable1238823gradable
grantable1257293grantable
grazable2036223grazable
gustable11138203gustable
habitable1645953habitable
hackable1937473hackable
hangable1438213hangable
hartal9415473harta_l_
hartals10313023harta_ls
hateable1339373hateable
hearable131611603hear_able
heatable131612043heatable
heritable1439453heritable
hirable121612313hir_able
hireable13139083hireable
hittable1336853hittable
huntable1338093huntable
imitable1239123imitable
inarable10313133inar_able
instable10313203instable
irritable1148053irritable
jailable1737143jailable
jammable2144513jammable
lapsable12117383lapsable
laudable1137893laudable
learnable1145563learnable
liftable1376863liftable
listable10810313listable
locatable1345573loca_table
mailable1239623mailable
makable15510203ma_kable
makeable1637253makeable
mappable1635923mappable
marble104219103mar__ble
marketable1843223marketable
maskable1638003maskable
meltable12310473meltable
mutable11312303_mutable
namable11312343na_mable
nameable1238863nameable
nestable101613673nestable
nettable101610243nettable
notable92114903_notable
packable1838633packable
paintable1337243paintable
palatable1346373palatable
palpable1448033palpable
parables121613563par_ables
parolable1347113parolable
partake1339643parta_ke
particle1239533particle
passable12310633passable
pawnable1535983pawnable
payable141711323pa_yable
pettable121710713pettable
plantable1337273plantable
portables1337873portables
portably1539313portably
potable112115363_potable
quotable1936493quotable
radiable11611303radiable
raisable10311643raisable
ratables10159723ra_tables
ratably121711513ra_tably
rateable10311443rateable
rentable101716333rentable
restable101618443restable
retable91820403_retable
rustable101511363rustable
sailable10310563sailable
salable91415463sa_lable
saleable10312023saleable
salvable1338403salvable
sandable111612823sandable
satiable10310733satiable
savable121711863sa_vable
saveable1339003saveable
sayable121411613sa_yable
scalable121710233sca_lable
scannable1345643scannable
scrutable1346043scrutable
servable13310093servable
sharable131910693shar_able
shareable1436733shareable
sorbable1239303sorbable
sortably1338803sortably
sparable121611983spar_able
spareable1337263spareable
stable83921643__stable
statable10310703statable
suitable10310893suitable
surfable1338443surfable
table75429603___table
takable13310193ta_kable
takeable1437463takeable
talkable1437193talkable
tamable11312853ta_mable
tameable1238603tameable
tannable1039383tannable
tapeable1238823tapeable
tappable1436343tappable
targetable1383873targetable
tartare73012683tarta_re
tasteable1146123tasteable
taxable1639073ta_xable
tearable101512673tear_able
testable101412623testable
tiltable10159013tiltable
titrable1038963titrable
totable92313363_totable
tractable1338513tractable
tradable1139873tradable
triable92515393_triable
turnable1037853turnable
turntable1144983turntable
unactable13310053unactable
unstable10313763unstable
vacatable1644643vacatable
valuable1336863valuable
variables1444673variables
variably1637433variably
veritable1448743veritable
votable122111373_votable
wadable13310233wa_dable
wadeable1437443wadeable
walkable1736063walkable
warble113516603war__ble
washable16138043washable
waxable1937673wa_xable
wearable131510553wear_able
wettable13148043wettable
wirable121610963wir_able
workable1737093workable
worktable1844723worktable
writable1338753writable

Search took 9 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.423422437.4
2DLD Change Limit1461623038.17317883.5
3Display Results3033030.1232463.4
 (SQL Overall)1786913038.71920494.4
 
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.