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

502 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
canaling11201641(None) 
canalling1239551canalling
candling122313871candling
aneling82719502_aneling
angling92816042_angling
ankling122912062_ankling
bantling112612002bantling
caballing1436882caballing
cabling124017552ca_bling
cackling172610942cackling
cageling12310842cageling
cajoling18318422cajoling
calling103826772ca_lling
canakin131810832canakin_
canakins142010462canakins
canalise10816212canalise
canalising1349362canalising
canalize19914492canalize
canalizing22410422canalizing
canceling14310162canceling
candying15188992candying
caning94128622can__ing
canning103620132can_ning
canoeing11310212canoeing
canting104725902can_ting
canvasing1546432canvasing
carling103727062ca_rling
caroling113317002caroling
castling11311232castling
catling104819792ca_tling
caviling14310112caviling
coaling103722822c_oaling
craaling112711352craaling
crankling16147292crankling
dandling112511732dandling
dangling112611232dangling
eanling81416672ean_ling
gangling112411402gangling
handling132312712handling
jangling17249622jangling
manacling1446282manacling
managing1239092managing
mangling122312622mangling
mantling112012612mantling
paneling111013622paneling
rankling132610112rankling
sandaling112010562sandaling
sandling102214412sandling
scandaling14195452scandaling
scantling12107232scantling
tangling101712542tangling
wangling132310992wangling
aahing1019015763_a_ahing
abasing10610673_abasing
abating10413973_abating
addling10229833_addling
ailing74331013_a_iling
amazing1938813_amazing
ambling121411793_ambling
anality10313633_anality
analog7159973_anal_og
analysing1345933_analysing
analyzing2245153_analyzing
anearing9413973_anearing
angeling102811733_angeling
anglings10228273_anglings
anilin6417793_anilin_
aniline7418473_aniline
anilins7416793_anilins
annealing1047453annealing
anteing8312813_anteing
anting75827023_an_ting
anviling1239743_anviling
argling92812733_argling
availing1267283_availing
awaking1547813_awaking
baaing94916163ba_a_ing
babbling12228693babbling
baffling1756053baffling
bailing103723523ba_iling
baling94829693__baling
balling104424763ba_lling
banality1338763banality
banalize191010933banalize
banalizing2248143banalizing
bandaging1436063bandaging
banding114921413ban_ding
bandying15218073bandying
banging114019863ban_ging
baning95127833ban__ing
banjaxing2642553banjaxing
banking144621353ban_king
banning103818233ban_ning
bantlings12216603bantlings
battling113110493battling
bawling133813863ba_wling
benaming1339693benaming
brandling1348253brandling
bundling12219703bundling
bungling12269543bungling
cabalism14310143cabalism
cabalist12314503cabalist
cabbaging1744093cabbaging
cabbing143613153ca_bbing
cabining1338643cabining
caching156317503ca_ching
caddying16225063caddying
cadging123610973ca_dging
cagelings1335413cagelings
caging105321023c__aging
caking134624673c__aking
calamine12314033calamine
calamint12315133calamint
calking144617783ca_lking
callings113613833ca_llings
calming123915973ca_lming
calquing2035593calquing
calving134113503ca_lving
cameoing1379063cameoing
camping143118973ca_mping
canaille1048413canaille
canal75428043canal___
canaled103615563canal_ed
canalised12810913canalised
canalises11515493canalises
canalized21611693canalized
canalizes201113783canalizes
canalled1139583canalled
canaller1038953canaller
canals84421663canal__s
canaries10318943canaries
cancelling1547213cancelling
canikin13189753canikin_
canikins14219163canikins
canine83826703can__ine
cankering162110793cankering
cannabin1266433cannabin_
cannabins1365783cannabins
cannings113710333can_nings
cannoning1237323cannoning
canoodling1443583canoodling
canopying1745063canopying
cantering122417373cantering
cantina93417253can_tina
cantoning12310883cantoning
canulating1349543canulating
canvassing1643803canvassing
canyoning1536873canyoning
capelin11510973capelin_
capelins12311133capelins
capering132414963capering
caplin103216303ca_plin_
caplins113515993ca_plins
capping143819673ca_pping
capsuling1444533capsuling
carabin11313213carabin_
carabine12412383carabine
carabins12312353carabins
caracoling1545633caracoling
carding113922433ca_rding
caring95137993c__aring
carking144322853ca_rking
carlin84421823ca_rlin_
carline93923613ca_rline
carlings114015853ca_rlings
carlins93921913ca_rlins
carnality1447593carnality
carolling1259413carolling
caroming133312963caroming
carping123521083ca_rping
carrying14148373carrying
carting104228283ca_rting
carving133916773ca_rving
cascading1545673cascading
caseating12311743caseating
cashing135022553ca_shing
casing94829103c__asing
casking144317353ca_sking
casting104628343ca_sting
catalog1038003catal_og
cataloging1444953cataloging
catalyzing2544773catalyzing
catcalling1545123catcalling
catching163712773catching
catenating1348683catenating
catering112019903catering
catfacing1744553catfacing
catlin83819083ca_tlin_
catlings113712043ca_tlings
catlins93818843ca_tlins
catnapping1742533catnapping
catting103922643ca_tting
cauline92215603ca_uline
caulking1536803caulking
causing103614413ca_using
cavalier1348173cavalier
cavatina1347333cavatina
cavatine13310323cavatine
caveating1539293caveating
cavilling1536383cavilling
caving124822613c__aving
cawing124322613c__awing
ceasing104118263c_easing
ceiling103416723c_eiling
celling103921263c_elling
censing104215263cen_sing
centring112112953centring
chafing163911493c_hafing
chalking183310063c_halking
chancing162810283chan_cing
changeling1745673changeling
changing153211513chan_ging
channeling1645203channeling
chanting143413533chan_ting
charing133721323c_haring
chasing133715893c_hasing
chawing164813033c_hawing
cheating144014523cheating
chilling143512183chilling
chitling142910663chitling
cinching163310223cinching
circling1338423circling
clanging124012123clan_ging
clanking154313063clan_king
clawing133812673c_lawing
claying133614303c_laying
cleaning113112383cleaning
clearing113014883clearing
cleating113518133cleating
cleaving141389683cleaving
cling86424673c___ling
cloaking15299713cloaking
coaming123818323c_oaming
coating103525313c_oating
coaxing173511703c_oaxing
cobbling15248803cobbling
cockling172310393cockling
coddling13258473coddling
codling114418953c_odling
coffling1736483coffling
coiling103723453c_oiling
comaking1739993comaking
comanaging1644323comanaging
concaving1737353concaving
concealing1549303concealing
condoling13510373condoling
congaing1239823congaing
congealing1447633congealing
coning94331823con__ing
conking143618453con_king
conning103718753con_ning
consoling12310873consoling
cooling103422573c_ooling
coupling13310783coupling
cowling134017423c_owling
crackling18157003crackling
cradling122411453cradling
cranching17278733cranching
craning103620303c_raning
cranking154613073cran_king
craping124018713c_raping
crating103725203c_rating
craving134015733c_raving
crawling143110513crawling
crazing193914583c_razing
creaking153414123creaking
creaming133413143creaming
creasing113314443creasing
creating113921953creating
creeling113513363creeling
creneling1247733creneling
crinkling16145863crinkling
croaking153712163croaking
cuddling13287653cuddling
culling103921303c_ulling
cunning104214623cun_ning
cupeling1338863cupeling
curating11314293curating
curdling12228893curdling
curling104320183c_urling
cuttling1138203cuttling
cyaniding1644803cyaniding
cycling1537213c_ycling
cymbling1834773cymbling
cymling1536273c_ymling
dabbling14227973dabbling
daddling12258233daddling
daggling12237063daggling
damaging1337383damaging
dancing113611563dan_cing
danging103716093dan_ging
dappling1436843dappling
darkling1437483darkling
darling93418363da_rling
dartling1039563dartling
dawdling14236373dawdling
dazzling1834363dazzling
dealing94323233_dealing
dialing94318173_dialing
dindling112411163dindling
donating10311803donating
eagling91113603ea_gling
eanlings9128473ean_lings
emanating1239003emanating
empaling1338363empaling
enabling1138603enabling
equaling1837793equaling
exhaling1936293exhaling
fabling133413623fa_bling
failing113521333fa_iling
falling113621583fa_lling
fancying1735353fancying
fanning113615073fan_ning
fatling113815683fa_tling
fenagling1434553fenagling
finagling1434703finagling
foaling113515843_foaling
fondling13189353fondling
gabbling14238073gabbling
gabling113514543ga_bling
gaggling10217463gaggling
galling93921963ga_lling
gambling14218963gambling
ganging103216193gan_ging
gantline9410903gantline
gaoling93314653ga_oling
garaging1139043garaging
garbling12249453garbling
gargling11239203gargling
gaveling133410163gaveling
gentling1048453gentling
gnarling10217603gnarling
gnawing12377903_gnawing
goaling93515333_goaling
hackling183310163hackling
haggling14227273haggling
hailing113820693ha_iling
haling104229783__haling
handing123518893han_ding
handlings14237343handlings
hangaring1438033hangaring
hanging123518703han_ging
hanking154619103han_king
hanseling1338063hanseling
hanting114124483han_ting
hassling1236803hassling
hauling113714433ha_uling
healing113922963_healing
hondling132210013hondling
impaling1338253impaling
inhaling1239523inhaling
inkling122911303_inkling
jailing153415843ja_iling
jingling17188573jingling
kayaking1534063kayaking
kindling14229623kindling
kraaling13186663kraaling
labeling11311643labeling
ladling92813393la_dling
lalling83519623la_lling
lancing103314123lan_cing
landing92819323lan_ding
landline9311443landline
lanolin7310643lanolin_
lanoline8311953lanoline
lanolins8310533lanolins
mackling172710063mackling
maculing13219583maculing
mailing102923343ma_iling
malling103623663ma_lling
manakin131810643manakin_
manakins14209763manakins
mandating1339773mandating
manning103616383man_ning
mantlings12207233mantlings
manuring1139223manuring
marbling13179883marbling
marling103322763ma_rling
mauling103315683ma_uling
medaling121912263medaling
menacing1339783menacing
metaling111613723metaling
mingling122010933mingling
nailing83419963na_iling
naming93917893__naming
napalming1443173napalming
noncling11310763noncling
paddling13218643paddling
paling93530133__paling
palling104024483pa_lling
pancaking1836383pancaking
pandying15217663pandying
panelings12107453panelings
panelling1239073panelling
panging113319113pan_ging
panning104019393pan_ning
panting104025423pan_ting
parading12313863parading
parawing14310583parawing
parling103823763pa_rling
paroling113316213paroling
pealing104123203_pealing
pedaling122412133pedaling
pindling122110983pindling
pungling12228663pungling
rabbling13239333rabbling
raddling11229773raddling
raffling1567063raffling
railing83325643ra_iling
rambling131810773rambling
ranching141712043ranching
ranging94120263ran_ging
ranking124320883ran_king
ranting84025413ran_ting
rassling939013rassling
rattling92510873rattling
ravaging1346323ravaging
raveling123414373raveling
regaling10315363regaling
renailing102813333renailing
renaming11313693renaming
rivaling1239913rivaling
runkling13217613runkling
saddling11239593saddling
sailing83927373sa_iling
sampling13510643sampling
sandalling1245873sandalling
sanding93520603san_ding
sandlings11238093sandlings
saning75127643san__ing
sapling103217863sa_pling
saunaing937013sauna_ing
savaging1356673savaging
scabbling1634863scabbling
scaling103519373_scaling
scandalling1543443scandalling
scanning113310773scan_ning
scanting113914763scan_ting
scantlings1393313scantlings
sealing83528563_sealing
shealing123415463shealing
shoaling123111753shoaling
signaling1136563signaling
singling101913003singling
skoaling13227213skoaling
snailing92912973snailing
snaking123915303_snaking
snaring83920953_snaring
snarling92513183snarling
snawing113612483_snawing
spangling1336373spangling
staling83925423_staling
stealing93416603stealing
tabling103216033ta_bling
tackling153211123tackling
tagalong1042763tagalong
tailing82923103ta_iling
tanging93419523tan_ging
tangoing10177893tangoing
tanking123918793tan_king
tanning83618253tan_ning
tattling9259473tattling
tingling102210823tingling
tinkling13239233tinkling
totaling9610303totaling
twangling1434453twangling
unaging9510933_unaging
unbaling11310683unbaling
unnailing1037023unnailing
unsling8313643_unsling
vacating14310353vacating
vailing113817943va_iling
vanning113912463van_ning
vealing114217423_vealing
vialing113614163_vialing
wabbling16207743wabbling
waddling14237933waddling
waffling1845423waffling
waggling14197063waggling
wailing113620903wa_iling
waling104525303__waling
walling113520973wa_lling
wambling16198443wambling
waning103623803wan__ing
wanking154216783wan_king
wanning113816213wan_ning
wanting114220173wan_ting
warbling14198943warbling
warsling12198593warsling
wattling12258783wattling
wauling112713113wa_uling
wawling143810963wa_wling
weanling12118643wean_ling
whaling143910773_whaling
windling132212263windling
winkling16298293winkling
wintling12249923wintling
wrangling1456223wrangling
yanking154512463yan_king
yawling14369183ya_wling
yealing112716383_yealing
yeanling12107063yean_ling

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.1561145455.1
2DLD Change Limit1461625027.75018859.6
3Display Results5025020.2032472.9
 (SQL Overall)1786915028.10922036.1
 
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.