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

153 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
canceler1223891(None) 
canceled13279391canceled
cancelers13247861cancelers
canceller1366681canceller
cackler153812572ca_ckler
canaller1038952canaller
cancel105316682cancel__
cancelled1456742cancelled
cancellers1445362cancellers
cancels114113312cancel_s
cancer104220922canc__er
cancered132411552cancered
candler103516592can_dler
channeler1444602channeler
concealer1368222concealer
conceder1338732conceder
lancelet1049472lancelet
acceder1235353_acceder
anele55628833_an_ele_
aneled74719273_an_eled
aneles64626293_an_eles
angeled93211503_angeled
angler74017863_an_gler
annealer845503_annealer
antler64615553_an_tler
banterer102811773banterer
cabler104519173ca__bler
cackle143416923ca_ckle_
cackled164613293ca_ckled
cacklers163710703ca_cklers
cackles153717203ca_ckles
cajoler16398393ca_joler
caller85125483ca__ller
cameleer1246033ca_meleer
canaled103615553can_aled
canalled1139573canalled
canallers1137213canallers
canceling14310163canceling
cancers114018583cance_rs
candela1089743candel_a
candelas1139533candelas
candider1237343candider
candle94321483can_dle_
candled113815733can_dled
candlers114214103can_dlers
candles104422343can_dles
canella9310793can_ella
caner75334773can___er
canicular1346463canicular
canister101710853canister
canker124422523can__ker
cankered153010223cankered
cannel84216403cannel__
cannelon1045123cannelon
cannels93413363cannel_s
canner84625983can__ner
cannier94014163can_nier
cannular1046283cannular
canoer85121073can__oer
canteen9411083cante_en
canter85230113can__ter
cantered113415983cantered
cantle84522153can_tle_
cantles94721413can_tles
canular9310323can_ular
canvaser13276553canvaser
capabler1435353capabler
capelet11517073ca_pelet
caperer113013403ca_perer
caracoler1346413caracoler
carcel105018673carcel__
carcels114516063carcel_s
careener1039323careener
career85822243ca_re_er
careerer1038583careerer
caroler93816753ca_roler
caroller1039203caroller
catcaller1344813catcaller
catcher143115823catc_her
catchier15329863catchier
caterer92815943ca_terer
catheter1338153catheter
caviler1249063ca_viler
caviller1337063caviller
chancel144011773chancel__
chancellery2152273chancellery
chancellor1752913chancellor
chancels15439083chancel_s
chancer144215633chanc__er
chancier1538823chanc_ier
chandelier1654293chandelier
chandler14358373chan_dler
channeled1544913channeled
channelers1543853channelers
chiseler1335903chiseler
chuckler1935553chuckler
circler1136423circ_ler
concealed1458133concealed
concealers1476913concealers
concede12310093concede_
conceded1438283conceded
conceders1437953conceders
concedes13311053concedes
conceiver1657413conceiver
concenter13312213concenter
conciser12310243conciser
condoler113412123condoler
congealer1256703congealer
congener112412203congener
consoler102812613consoler
convener132913163convener
conveyer16278143conveyer
crueler939023c_rueler
cudgeler1253313cudgeler
cupeler1177483c_upeler
cycler1335913c_yc_ler
dancer94817613danc__er
dandler94414273dan_dler
dangler96912813dan_gler
enameler1045883enameler
fancier123412063fanc_ier
hackler163512353ha_ckler
handler113516163han_dler
hankerer15248233hankerer
hanseled1237713hanseled
jangler153811833jan_gler
kantele1138253kantele_
kanteles1238123kanteles
kneeler11277573_kneeler
labeler92310183la_beler
lancelets1144833lancelets
lancer84319973lanc__er
lanceted1137073lanceted
landler84113203lan_dler
larcener1036493larcener
mangler103215643man_gler
mantelet10613823mantelet
marceller1345153marceller
panderer112210913panderer
paneled10612573pan_eled
parceled1338333parceled
parcener1238473parcener
penciler1237113penciler
rancher123013633ranc_her
raveler104212463ra_veler
sincerer1037203sincerer
spanceled1443693spanceled
tackler134013323ta_ckler
tangler83515073tan_gler
tunneler864473tunneler
uncanceled1543813uncanceled
wanderer122210123wanderer
wangler113312653wan_gler

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 Filter1786911461620.1561145455.1
2DLD Change Limit1461621537.45319611.2
3Display Results1531530.0632428.6
 (SQL Overall)1786911537.67223291.3
 
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.