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

402 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
candids11381269(None) 
candid104517851candid_
candida114110251candida
candidas12338651candidas
candies104125611candies
canids95118131can_ids
bandies104124862bandies
bandits103814792bandits
caddies113718382caddies
caddis104613382caddi_s
cadis84428502ca_di_s
caids85226422ca__ids
canards10311202canards
candidal12367742candidal
candider1237342candider
candidest1346532candidest
candidly1545212candidly
candied113816022candied
candles104422342candles
candors104216762candors
canid85526342can_id_
capsids1239332capsids
cardias10715122cardias
conoids10813882conoids
cyanids13297932cyan_ids
dandies94121442dandies
gadids95611822ga_dids
ganoids939332ganoids
mantids103113622mantids
nandins8312002nandins
pandies104224502pandies
pandits103914212pandits
randies84225662randies
ranids75118702ran_ids
scandias1137862scandias
acarids105312243acarids
acedias1039773acedias
acids87121003_a_cids
adds67622453_a_d_ds
adios65822863_a_dios
adits66523713_a_dits
aids57846363_a__ids
alcids94812293_alcids
amids85627513_a_mids
androids1047753_androids
andros7313303_andros
ands57833613_an__ds
anils56326723_an_ils
anis45746463_an_i_s
antics84621453_antics
antis55033313_anti_s
anvils9219713_anvils
aphids125110843_aphids
araneids947743araneids
aroids75118223_aroids
asdics9439863_asdics
audads8167103_audads
audios72312283_audios
audits72814113_audits
avoids104410203_avoids
baddies114017873baddies
baldies105317703baldies
bandaid11310483bandaid_
bandas95120543band_as
banded105223173banded_
banders104324563banders
bandied114414303bandied
banding114921413banding
bandit93821133bandi_t
bandito103710043bandito
banditos11347633banditos
bandogs1138363bandogs
bands85233433ban__ds
bankits133410153bankits
banties94324763banties
bawdies134613393bawdies
bindis94614583bindi_s
brandies11714563brandies
cabbies133115163cabbies
cabins104418923ca_bins
caddice13327733caddice
caddices14297853caddices
caddie104316453caddi_e
caddied123710563caddied
caddises12329353caddises
caddish143810133caddish
caddy125414023ca_d_dy
cades85440733ca_d_es
cadets96316513ca_dets
cadges104716713ca_dges
cadi75732183ca_di__
cadres94017933ca_dres
cads76144523ca___ds
caid77837533ca__id_
cains75334303ca__ins
cairds96411513ca_irds
calends1039523calends
califs114915893ca_lifs
calkins133814873calkins
camails11311753camails
camelids1356943camelids
cammies134016483cammies
canakins142010463canakins
canals84421673can_als
canapes111213083canapes
canard9314763canard_
canaries10318943canaries
cancans11311873cancans
cancels114113313cancels
cancers114018583cancers
canchas143212403canchas
cancroids1444533cancroids
candela1089743candela
candelas1139533candelas
candent10417363candent
candidacy1852363candidacy
candidate1356663candidate
candidates1446303candidates
candidness1444773candidness
candle94321483cand_le
candled113815743candled
candler103516593candler
candlers114214103candlers
candling122313873candling
candor94516423cand_or
candour104210243candour
candours11408643candours
candy115119823can__dy
candying15188993candying
caned85838093can_ed_
caners84629203can_ers
canes75350373can__es
canfields1542833canfields
canfuls1248423canfuls
cangues10611823cangues
canikins14219163canikins
canine83826703can_ine
canines93724033canines
caning94128623can_ing
canities101519263canities
cankers134418753cankers
cannas84518403can_nas
canned95022063canned_
cannels93413363cannels
canners93822663canners
cannie83819363canni_e
cannier94014163cannier
canniest10313363canniest
cannily1239263cannily
canning103620133canning
cannings113710333cannings
cannons94412883cannons
canoed94618963canoed_
canoers94318373canoers
canoes84725883can_oes
canolas9313993canolas
canons85522063can_ons
canopies12311853canopies
cans65050853can___s
cansos84915383can_sos
cantals93919573cantals
cantdogs1244043cantdogs
canted94825783canted_
canters94827733canters
canthus1248713canthus
cantic103920543canti_c
cantina93417253cantina
cantinas102713783cantinas
canting104725903canting
cantles94721413cantles
cantons95221203cantons
cantors94620753cantors
cantos84826973can_tos
cantrips12318933cantrips
cants77036943can__ts
cantus85117763can_tus
canulas9312853canulas
canvas113813333can_vas
canvass12376873canvass
canyons124511593canyons
capias10318353ca_pias
caplins113515993caplins
capris10415083capri_s
capsid11312413capsid_
carabids1338193carabids
carangids1344573carangids
carbide126112493carbide
carbides133111693carbides
carded105424903carded_
carders104820353carders
cardia9916383cardi_a
cardiac1278823cardiac
cardiacs1376923cardiacs
cardiae10713713cardiae
carding113922443carding
cardings123812643cardings
cardio9915673cardi_o
cardioids1345233cardioids
carditis11310233carditis
cardons104519943cardons
cards85137933ca__rds
caries85147623ca_ries
carlins93921923carlins
carnies94123963carnies
carotids11229943carotids
carries94328013carries
caseins93115053caseins
cassias93514343cassias
cassis84818853cassi_s
catbirds1344203catbirds
catenoids1246433catenoids
catkins133012563catkins
catlins93818843catlins
catnips1195893catnips
catties94023053catties
caudad10157673caudad_
caudices13337343caudices
caudles103912813caudles
caulds95512383ca_ulds
caulis85320083cauli_s
cavies114525003ca_vies
cavils114014393ca_vils
cebids11439173c_ebids
ceboids1237653ceboids
cedis84317083c_edi_s
chalcids1635893chalcids
chanties132615803chanties
cinders104617763cinders
clerids1049093clerids
cnida878953c_n_ida
coccids11277213coccids
coedits10310243coedits
condign1147733condign
condoes104319203condoes
condoms124214083condoms
condors104018573condors
condos94322333cond_os
conduits111210063conduits
confide13310203confide
confides14310573confides
confits122811423confits
congius103210073congius
conics103920593con_ics
conies84338593con_ies
conins84327233con_ins
conoid9818883conoid_
corvids1337683corvids
cosmids1237633cosmids
crannies10313013crannies
crawdads1542653crawdads
credits1039973credits
crinoids1147363crinoids
cuboids1236723cuboids
cuddies113313263cuddies
cundums1235183cundums
cupids11369193c_upids
cuspids12427113cuspids
cyanamids1743163cyanamids
cyanid123912043cyan_id_
cyanide13298843cyan_ide
cyanides14258003cyanides
cyanins122910013cyan_ins
cynics13377363cyn_ics
daddies103414943daddies
danders93921183danders
dandier93714573dandier
dandiest103415033dandiest
dandify15245673dandify
dandily12279633dandily
dandles94218533dandles
danios7314603dan_ios
fancies124018783fancies
fandoms13229473fandoms
fanfics1535173fanfics
fannies103415643fannies
fantods11177623fantods
gaddis94211373gaddi_s
gadid85517383ga_did_
gadis74825293ga_di_s
gadoids1036873gadoids
ganders93521703ganders
ganoid8314443ganoid_
gaudies9311973gaudies
grandads1136553grandads
grandkids1643143grandkids
halids104016133ha_lids
haloids113012553haloids
handed114919983handed_
handers114224333handers
handier113817443handier
handiest123417783handiest
handily143610873handily
handing123518893handing
handles114020653handles
handmaids1644543handmaids
hands95327383han__ds
hankies143617763hankies
hardies114923233hardies
indies73822783_indies
iodids83711153_iodids
ixodids16213363ixodids
jassids1586143jassids
kadis105921063ka_di_s
kanjis1735963kanji_s
katydids1741603katydids
laddies93715053laddies
ladies75124883la_dies
lanais6316793lanai_s
landaus8310343landaus
landed84619243landed_
landers84026213landers
landing92819323landing
landings103110073landings
lands65426903lan__ds
landside10147443landside
landsides11116743landsides
lindies8416583lindies
maids86327143ma__ids
mandrils1138493mandrils
manias84029033man_ias
manics103919933man_ics
mantid93820383mantid_
mantis83926033manti_s
masjids17175403masjids
maundies1137853maundies
nadirs7109003na_dirs
nancies93516843nancies
nandin7313033nandi_n
nandina838913nandina
nandinas936583nandinas
nankins1159053nankins
nannies73015203nannies
navaids1134803navaids
paddies113715723paddies
padis86227143pa_di_s
pandas95521963pand_as
panders103423733panders
pandied113913443pandied
pandit93820753pandi_t
panics103815363pan_ics
pansies94521983pansies
panties94230933panties
pongids11347413pongids
pundits10379293pundits
qadis155917853qa_di_s
qaids156116313qa__ids
radios74018673ra_dios
radius73914873ra_dius
raids65827513ra__ids
rancid9513863rancid_
randans8313213randans
randier83618473randier
randiest93418773randiest
randoms102112433randoms
rands65930453ran__ds
ranid66429333ran_id_
ranis55235833ran_i_s
rapids94913893ra_pids
sadis64930853sa_di_s
saids65328853sa__ids
saiyids11174893saiyids
salpids1038193salpids
sandals82715203sandals
sanded84920613sanded_
sanders84025943sanders
sandhis1139993sandhis
sandier84017843sandier
sandiest93218693sandiest
sanding93520603sanding
sandpits1146843sandpits
sands65228583san__ds
sanies63031953san_ies
santims9312603santims
santirs7312963santirs
sardius839553sardius
sayids104310973sa_yids
sayyids14193833sayyids
scandals1136993scandals
scandia1038063scandi_a
scandic1237003scandi_c
scandium1365693scandium
scandiums1443983scandiums
scanties103215423scanties
shandies122714113shandies
syndics1335703syndics
tandems1037633tandems
tannins72813223tannins
tansies74521243tansies
tardies84225863tardies
tineids8337873tineids
uncandid1244603uncandid_
undid72415363_undid_
undies73821963_undies
vandals113211663vandals
vandas103915993vand_as
waddies124214753waddies
wadies105121203wa_dies
wadis95223963wa_di_s
wanders114221333wanders
wands96425483wan__ds
zanders173015793zanders
zanies153219673zan_ies

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.423422437.4
2DLD Change Limit1340274026.68620045.9
3Display Results4024020.1432811.2
 (SQL Overall)1786914027.25224640.2
 
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.