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

208 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
canceled1327940(None) 
canceler12238911canceler
cancelled1456741cancelled
cancered132411551cancered
aneled74719282_an_eled
angeled93211512_angeled
cackled164613302ca_ckled
canaled103615562can_aled
canalled1139582canalled
cancel105316682cancel__
cancelers13247862cancelers
canceller1366682canceller
cancels114113312cancel_s
candled113815742can_dled
cankered153010222cankered
cantered113415992cantered
channeled1544912channeled
concealed1458132concealed
conceded1438292conceded
hanseled1237712hanseled
lancelet1049472lancelet
lanceted1137072lanceted
paneled10612572pan_eled
parceled1338342parceled
spanceled1443692spanceled
uncanceled1543812uncanceled
acceded1336113_acceded
anele55628833_an_ele_
aneles64626293_an_eles
angered93013473_angered
angled84219093_an_gled
ankled114313483_an_kled
annealed936343_annealed
annelid838733_annelid
annexed1535753_annexed
anteed75616113_ante_ed
anviled1138953_anviled
bannered11299323bannered
bantered113313653bantered
barreled1137853barreled
caballed1337163caballed
cabled114819873ca__bled
cached145419203ca_c_hed
cacheted16148233cacheted
cackle143416923ca_ckle_
cackler153812573ca_ckler
cackles153717203ca_ckles
cajoled17428283ca_joled
calcined1338743calcined
called94126733ca__lled
camailed1336553camailed
cambered15129003cambered
camelid1249413ca_melid
cameoed1238383ca_meoed
canaller1038953canaller
canceling14310163canceling
cancellers1445363cancellers
cancer104220923canc__er
cancers114018583cance_rs
cancroid1346523cancroid
candela1089743candel_a
candelas1139533candelas
candied113816023can_died
candle94321483can_dle_
candler103516593can_dler
candles104422343can_dles
caned85838093can___ed
canella9310793can_ella
canfield1444333canfiel_d
canned95022063can__ned
cannel84216403cannel__
cannelon1045123cannelon
cannels93413363cannel_s
cannoned11118143cannoned
canoed94618963can__oed
canoodled1342803canoodled
canopied1336353canopied
canted94825783can__ted
canteen9411083cante_en
cantle84522153can_tle_
cantles94721413can_tles
cantoned111411523cantoned
canvased14246223canvased
capelet11517073ca_pelet
capered123014043ca_pered
capsuled1334533capsuled
caracoled1445993caracoled
carcel105018673carcel__
carcels114516063carcel_s
careened1139193careened
careered1139503careered
caroled103717693ca_roled
carolled1138833carolled
carpeted1338953carpeted
cascaded14135703cascaded
casketed1534953casketed
castled104311513ca_stled
catcalled1444893catcalled
catered103117783ca_tered
caucused1344093caucused
caviled1348723ca_viled
cavilled1436733cavilled
centered112513523centered
chanced154113213chanc__ed
chancel144011783chancel__
chancels15439093chancel_s
chandelled1744273chandelled
channeler1444603channeler
channelled1644143channelled
chiseled1435883chiseled
chuckled2045163chuckled
cinched153910863cinc_hed
cindered1239793cindered
circled1237583circ_led
coannexed1942953coannexed
cockled163710823c_ockled
concaved1636223concaved
concealer1368223concealer
concede12310103concede_
conceder1338743conceder
concedes13311063concedes
conceited14310423conceited
conceived1746713conceived
concerned1438643concerned
concerted14312113concerted
concreted1439413concreted
condoled123110723condoled
congealed1346593congealed
congeed113212313conge_ed
consoled112911453consoled
convened143412223convened
conveyed17247923conveyed
corbeled1338373corbeled
counseled1245053counseled
crackled17428863crackled
cranched163210413cranc_hed
crankled15408153cran_kled
creeled104012013c_reeled
creneled11326893creneled
cudgeled1343123cudgeled
cupeled1257793c_upeled
cycled1436543c_yc_led
danced105315253danc__ed
dandered112110963dandered
dandled103313543dan_dled
dangered11248513dangered
dangled104013153dan_gled
easeled8159863ea_seled
enameled1136373enameled
faceted13509563fa_ceted
fancied133310603fanc_ied
flanneled1343313flanneled
funneled1254873funneled
gandered112211173gandered
gaveled12399133ga_veled
hackled173312493ha_ckled
handled124114533han_dled
handseled1444403handseled
hankered16289443hankered
hanselled1345483hanselled
hatcheled1844223hatcheled
jangled164111563jan_gled
kantele1138253kantele_
kanteles1238123kanteles
kenneled1334003kenneled
kneeled12328073_kneeled
labeled102510563la_beled
lanced93717723lanc__ed
lancelets1144833lancelets
lapeled10258893la_peled
laureled934543laureled
mackled164111923ma_ckled
macled116718113ma_c_led
maculed123510053ma_culed
manacled1336453manacled
mangled113615263man_gled
mannered11249653mannered
mantelet10613823mantelet
mantled104113393man_tled
marcelled1445203marcelled
marveled1436433marveled
pancaked1734893pancaked
pandered121812573pandered
panelled1138963panelled
panicled13106783panicled
pantiled113111593pantiled
parcelled1445783parcelled
penciled1337823penciled
precanceled1852453precanceled
racemed1237013ra_cemed
ranched133113603ranc_hed
rancored1137233rancored
rankled123910653ran_kled
rappeled1335003rappeled
raveled114113633ra_veled
sandaled1039243sandaled
satcheled1544423satcheled
scandaled1344663scandaled
spancelled1543003spancelled
tackled143913193ta_ckled
tangled94214643tan_gled
tasseled935603tasseled
tinseled935763tinseled
tunneled955233tunneled
unaneled939793unaneled
unceded11410563_unceded
wandered132110793wandered
wangled123312413wan_gled

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 Limit1461622088.25017716.6
3Display Results2082080.0762736.8
 (SQL Overall)1786912088.74920424.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.