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

412 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
canulas931285(None) 
cannulas1037581cannulas
canolas9313991canolas
canula8312961canula_
canulae9311181canulae
canular9310321canular
ranulas7311771ranulas
anlas55626932_an_las
cabalas113516002cabalas
callas84526752ca_llas
canals84421662canal_s
canchas143212402canchas
candelas1139532candelas
candles104422342candles
canellas10310562canellas
canfuls1248422canful_s
cannas84518402can_nas
cannula937432cannula_
cannulae1046492cannulae
cannular1046282cannular
canola8313622canola_
cantalas104013522cantalas
cantals93919572cantals
cantles94721412cantles
canulate10314552canulate
canulates11312862canulates
canvas113813332can_vas
casuals91410522casuals
caulds95512382ca_ulds
caules85927252ca_ules
caulis85320072ca_ulis
caulks125611862ca_ulks
cauls75727772ca_ul_s
cedulas1058502cedulas
copulas113811562copulas
maculas113114012maculas
manilas93915872manilas
manuals9311212manuals
radulas839582radulas
ranula6311812ranula_
ranular739432ranular
scapulas1246132scapulas
zonulas1637022zonulas
abulias93210693_abulias
aciculas12228553aciculas
adults7299953_adults
ajugas1435263_ajugas
akelas10311193_akelas
alas46358123_a__las
alula5317093_alula_
alulae6312743_alulae
alular6311353_alular
anabas8314083_anabas
anas46649863_an__as
aneles64626293_aneles
angas65827983_an_gas
angles74426703_angles
anglos74413903_anglos
angular838533_angular
anils56326723_anil_s
animas84418723_animas
ankles104818383_ankles
annals66415923_annals
annas55824883_an_nas
annuals7388193annuals
annular737693annular
annuls64711733annul_s
annulus7426613annulus
anoas57226493_an_oas
anoles64827423_anoles
antas55432033_an_tas
anural65714743_anural
anuran64313243_anuran
anurans73810553_anurans
anurias7312243_anurias
anus47131113_anu__s
anuses66218773_anuses
aquas142412613_aqu_as
atlas55821583_a_tlas
auras55932553_a_uras
babuls105413643babul_s
bacula103112673bacula_
balas76937213ba__las
bananas93312223bananas
bandas95120543ban_das
bangles103617413bangles
baulks12429373ba_ulks
cabala103516913cabala_
cabals104020153cabal_s
cabanas112413033cabanas
cabbalas1467373cabbalas
cables104527553ca_bles
cacas95627983ca__cas
cackles153717203cackles
caeomas1138393caeomas
caesuras1055723caesuras
cajoles163712103cajoles
calash11312433ca__lash
calculus1255333calculus
calendulas1372023calendulas
calesas9411823calesas
calfs104919383ca__lfs
calks115421603ca__lks
calla74827073ca_lla_
callan83619603ca_llan
callans94518473ca_llans
calls75634733ca__lls
callus85317073ca_llus
calms95222353ca__lms
calos74431903ca__los
camas96333523ca__mas
camelias12510293camelias
camels105217083camel_s
cameras11313343cameras
camisas113411923camisas
campanulas1652283campanulas
canal75428043can__al
canaled103615553canaled
canalise10816213canalise
canapes111213083canapes
canards10311203canards
canastas1037693canastas
cancan10314103can_can
cancans11311873cancans
cancels114113313cancels
cancers114018583cancers
cancha134411613cancha_
candela1089743candela_
candidas12338643candidas
candids113812693candids
candies104125613candies
candle94321483candl_e
candled113815733candled
candler103516593candler
candlers114214103candlers
candors104216763candors
canella9310793canella
caners84629193can_ers
canes75350373can__es
canful11610263canful__
cangues10611823cangues
canicular1346463canicular
canids95118133can_ids
canines93724033canines
cankers134418753cankers
canna75919333can_na_
cannels93413363cannels
canners93822663canners
cannolis1037863cannolis
cannons94412883cannons
cannulate1148633cannulate
cannulates1247783cannulates
canoers94318373canoers
canoes84725883can_oes
canons85522063can_ons
cans65050843can___s
cansos84915383can_sos
cantal84122033can_tal
cantala94114673cantala
cantatas103410083cantatas
canters94827723canters
canthal12410053canthal
canthus1248703canthus
cantinas102713773cantinas
cantle84522153cantl_e
cantons95221203cantons
cantors94620753cantors
cantos84826973can_tos
cantrap113310273cantrap
cantraps12319113cantraps
cants77036943can__ts
cantus85117763can_tus
canulated12310673canulated
canvass12376873canvass
canyons124511593canyons
canzonas1935383canzonas
capelan1139003capelan
capelans1238013capelans
capfuls1436523capful_s
capias10318353ca_pias
capsular1245403capsular
capsules1236623capsules
cardias10715093cardias
carfuls1249133carful_s
carinas93622383carinas
caritas93316943caritas
carles85435083ca_rles
carls77037423ca_rl_s
carnaubas1342913carnaubas
carols85124983carol_s
carolus94612603carolus
carpals113414623carpals
casabas1139983casabas
casas75327843ca__sas
casavas1237813casavas
casitas93312043casitas
cassias93514343cassias
castles94917733castles
casual81112863casu_al
casus76419253casu__s
catalase1039213catalase
catalos9414163catalos
catalpas1246733catalpas
catclaw1443973catclaw
catclaws1543633catclaws
catenas9313103catenas
caucus1039603ca_ucus
caudad10157673ca_udad
caudal91611483ca_udal
caudles103912813caudles
caul65630003ca_ul__
cauld85318443ca_ul_d
caulk115315453ca_ul_k
causal81413203ca_usal
causals91411183ca_usals
causes88026473ca_uses
cavallas1366843cavallas
cavils114014393cavil_s
cayuses12188403cayuses
cedula977643cedula_
centals94317053centals
centas85020703cen_tas
cesuras958683cesuras
challas124414123challas
chalupas1554383chalupas
chelas113817203c_helas
chimlas1437453chimlas
cholas114817993c_holas
chollas123811353chollas
chufas14397673c_hufas
cicalas1139293cicalas
cinemas1138023cinemas
cingula10327163cingula_
cingular11256963cingular
citolas939343citolas
coagula1045403coagula_
coagulase1293393coagulase
coalas87418963c_oalas
colas75436773c__olas
conchas144013313conchas
congas94417033con_gas
consular1038813consular
consuls92412313consul_s
consults10219983consults
contras93015603contras
conus76726533conu__s
copula102812043copula_
copulae112810613copulae
copular113810603copular
coulis84018753c_oulis
crankles143510153crankles
crapolas1247403crapolas
culls75425813c__ulls
culms95314193c__ulms
cults75022553c__ults
cumulus1135453cumulus
cupolas11277753cupolas
cupula10328433cupula_
cupulae11347853cupulae
cupular11317623cupular
cupules113210263cupules
cutlas8313093c_utlas
dandles94218533dandles
dangles93618423dangles
daturas838763daturas
doulas75114993_doulas
fabular12288693fabular
facula112912233facula_
faculae123210353faculae
facular122810443facular
famulus1235043famulus
fanegas1145713fanegas
fangas105017193fan_gas
fanums1137263fanu_ms
faulds10438963fa_ulds
faults94513553fa_ults
faunas94013633fa_unas
favelas1337023favelas
ferulas103110753ferulas
fibulas12228563fibulas
galas65731643ga__las
ganjas14149113gan_jas
gaults74112783ga_ults
granolas938053granolas
granular946893granular
granules939933granules
halalas104214083halalas
hamular1236973hamular
hamulus1235323hamulus
handles114020653handles
hansas94616043han_sas
hantles104117513hantles
hanuman1237123hanuman
hanumans1344943hanumans
haulms11558503ha_ulms
hauls86123733ha_ul_s
hawalas13348353hawalas
hulas84920883__hulas
inulase739413_inulase
jangles154015683jangles
kabalas133911063kabalas
kahunas1473953kahunas
kamalas13339123kamalas
kanakas10327213kanakas
kanas95326913kan__as
lacunas9138173lacunas
lagunas8156823lagunas
lanugos834453lanugos
lauras63414333la_uras
lazulis1634903lazulis
ligulas8329163ligulas
lunula636173lunula_
lunulae735613lunulae
lunular736013lunular
lunules738953lunules
macula103013673macula_
maculae113412863maculae
macular113011943macular
macules114015133macules
mananas93414733mananas
manas76240423man__as
mandalas1139433mandalas
mandolas1139133mandolas
mangas94122923man_gas
mangles104021463mangles
manias84029033man_ias
manila84518303manila_
manillas102611163manillas
mannas85019803man_nas
mantas85725363man_tas
mantles94820703mantles
mantras93815863mantras
mantuas93410993mantuas
manual8313463manu_al
manures9313353manures
manus75924923manu__s
maquilas1944033maquilas
masalas9312053masalas
mauls76524953ma_ul_s
mazumas2034623mazumas
morulas959703morulas
nalas55528363__nalas
nanas55928633nan__as
nebulas957583nebulas
nulls55019983__nulls
pabular11259473pabular
paellas9411413paellas
panadas103312213panadas
panamas113112753panamas
pandas95521963pan_das
panduras1136943panduras
panels84716523panel_s
panfuls1237173panful_s
pangas99921103pan_gas
papula103011113papula_
papulae11249353papulae
papular11299763papular
papules112411573papules
paruras9310533paruras
payolas12148973payolas
penults937123penults
planula935773planula_
planulae1044793planulae
planular1044753planular
qabalas18289503qabalas
radula749313radula_
radulae837963radulae
radular837833radular
ramblas112710263ramblas
rankles113114543rankles
sandals82715203sandals
sangas75222653san_gas
sauls55128123sa_ul_s
saults65816173sa_ults
saunas63915433sa_unas
scandals1136993scandals
scandias1137863scandias
scapula1136343scapula_
scapulae1255433scapulae
scapular1245373scapular
scapulars1343873scapulars
scopulas1265483scopulas
spatulas1045473spatulas
tablas83716163ta_blas
tabular9279763tabular
tabulis938833tabulis
talas55935893ta__las
talukas11316213talukas
tangles83920043tangles
tankas104613763tan_kas
tantras73112093tantras
tanukis1134713tanukis
torulas759843torulas
uvulas946523_uvulas
valutas1036533valutas
vandals113211663vandals
vandas103915993van_das
vanillas11228123vanillas
vaults94511673va_ults
venular1037683venular
venules104011483venules
wallas95719393wa_llas
wangles113416933wangles
wauls86120553wa_ul_s
yamulkas1741793yamulkas
yantras10259003yantras
zananas16319563zananas
zanzas1487053zan_zas
zonula1537223zonula_
zonulae1645963zonulae
zonular1656493zonular
zonules1647793zonules

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.186960704.3
2DLD Change Limit1340274127.25018486.5
3Display Results4124120.1402942.9
 (SQL Overall)1786914127.57623586.5
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.