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

466 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
catenas931310(None) 
catena8312471catena_
catenae9311361catenae
arenas65021992_arenas
cabanas112413032cabanas
cadenzas2053742cadenzas
calends1039522calends
calesas9411822calesas
cameras11313342cameras
cannas84518402ca_nnas
cantinas102713772cantinas
carinas93622382carinas
cassenas10317482cassenas
catenary1346582catenary
catenate10312832catenate
catenates11311802catenates
cateran9313762cateran
caterans10313202caterans
caters85336492cate_rs
cates75951872cate__s
catnap1098382cat_nap
catnaps1197032cat_naps
faenas94412762fa_enas
galenas83310332galenas
latens64620212laten_s
latents75214312latents
latinas74416462latinas
patens84820862paten_s
patents94815202patents
patinas96318522patinas
accents113511233accents
achenes12313493achenes
actinal9312293actinal
actings104512463actings
actinias101810843actinias
actins86321103actin_s
agendas936933_agendas
agenes74720253_agenes
agents74816293_agents
akelas10311193_akelas
akenes104817343_akenes
amebas10311453_amebas
amends94713283_amends
amens75624843_amen_s
aments85219803_aments
anas46649863_a__nas
annas55824883_a_nnas
antennas846403antennas
apneas83211383_apneas
areas55935773_are_as
arecas84817443_arecas
arena55323813_arena_
arenes64928393_arenes
arepas85515703_arepas
asanas6514113_asanas
ates45047923_ate__s
atlas55821583_at_las
atmans84413963_atmans
atmas75721013_at_mas
atonal6514023_atonal
atones65225773_atones
atonias73315993_atonias
attends8257593attends
avens86419333_aven_s
bananas93312223bananas
bantengs1134593bantengs
bartends1136793bartends
bateau8810563bate_au
bates75846343bate__s
batons85519423baton_s
battens95313263batten_s
butenes9313033butenes
cabalas113516003cabalas
cabana103913563cabana_
cabers105023903cabe_rs
cabins104418913cabin_s
cacas95627983ca__cas
cadence1239063cadence
cadences1338473cadences
cadency1545893cadency
cadent94120353caden_t
cadenza1943773cadenza
cades85440733cade__s
cadets96316503cade_ts
caeca93915133ca_eca_
caecal103713733ca_ecal
caeomas1138393caeomas
caesar8410933ca_esar
caesars9410723ca_esars
cafes106426923cafe__s
caftans12179443caftan_s
cagers95624183cage_rs
cages85936013cage__s
caimans113811783caimans
cains75334303ca_in_s
cairns85313303cairn_s
cajones163311333cajones
cakes116037673cake__s
calderas1147863calderas
calendal1145383calendal
calendar1145013calendar
calendars1244523calendars
calesa8412473calesa_
callans94518473callans
callas84526753ca_llas
camas96333523ca__mas
camelias12510293camelias
camels105217083came_ls
cameos105818003came_os
camera10313673camera_
camerae11312043camerae
cameral11311263cameral
cames97047313came__s
camisas113411923camisas
canal75428043ca__nal
canals84421663ca__nals
cancans11311873cancans
canchas143212403canchas
candelas1139533candelas
canellas10310563canellas
caners84629193cane_rs
canes75350373ca__nes
canines93724033canines
canna75919333ca_nna_
cannels93413363cannels
canners93822663canners
canolas9313993canolas
canons85522063canon_s
cans65050843ca__n_s
cantalas104013523cantalas
cantatas103410083cantatas
canteens1038573canteens
canters94827723cante_rs
cantilenas1243863cantilenas
cantina93417253cantina_
cantonal1038903cantonal
cantons95221203canton_s
cants77036943ca__nts
canulas9312853canulas
canvas113813333ca_nvas
canzonas1935383canzonas
capelan1139003capelan
capelans1238013capelans
capers105428133cape_rs
capes95441923cape__s
capias10318353ca_pias
capons104119503capon_s
captans111612053captan_s
cardias10715093cardias
careens94514703careens
careers95218783careers
carers85133953care_rs
cares77369183care__s
caress85720263care_ss
carets85330773care_ts
carina84325323carina_
carinae94318583carinae
carinal94318223carinal
caritas93316943caritas
carnal83919203ca_rnal
carnets93918403carnets
carneys124310543carneys
carns75937563ca_rn_s
carotenes11410203carotenes
cartels94618123carte_ls
carters95327243carte_rs
cartes86239473carte__s
cartons94122473carton_s
casabas1139983casabas
casas75327843ca__sas
casavas1237813casavas
casease939323case_ase
caseins93115053caseins
caseous9312513caseous
casernes103810753casernes
caserns94711213caserns
cases75048383case__s
casings104013513casings
casinos93512833casinos
casitas93312043casitas
cassena9287843cassena_
cassenes103611293cassenes
cassias93514343cassias
cassinas103610633cassinas
casters94729893caste_rs
castes85631863caste__s
castings113614053castings
catalase1039213catalase
catalos9414163catalos
catalpas1246733catalpas
catawbas1544093catawbas
catboat11412243catboat
catboats1247863catboats
catches144320763catches
catclaw1443973catclaw
catclaws1543633catclaws
cate66254593cate___
catechu1444473catechu
catechus1544813catechus
catenaries1248663catenaries
catenated1238913catenated
catenoid1149113catenoid
catenoids1246423catenoids
cater74840703cate__r
catered103117763catered
caterer92815933caterer
caterers102814393caterers
cateress102311603cateress
catguts1045313catguts
cathead1338753cathead
catheads1438103catheads
cathects1545793cathects
cathedras15104803cathedras
cathexes2036273cathexes
cathexis2045753cathexis
cations94524143cations
catjang1733923catjang
catjangs1843223catjangs
catkins133012563catkins
catlings113712043catlings
catlins93818843catlins
catmints1236663catmints
catnip1097963cat_nip
catnips1195893catnips
cats66356343cat___s
catspaw1443353catspaw
catspaws1543163catspaws
catsups1135333catsups
catties94023053catties
cattleyas1442623cattleyas
cavatinas1444773cavatinas
caveat11417723cave_at
caveats1239803caveats
caveman1437073caveman
caverns124510243caverns
cavers115026833cave_rs
caves105639703cave__s
cavings134712543cavings
cayenne1244603cayenne
cayennes1345013cayennes
caymans14349513caymans
cements112714223cements
centas85020703c__entas
cents74730333c__ents
cetanes9315133cetanes
cetes75731103cete__s
chastens13429183chasten_s
chateau1236263chate_au
chateaus1345983chateaus
chelas113817203c_helas
chinas115119383c_hinas
cinemas1138023cinemas
citers85022973cite_rs
cites74435583cite__s
citolas939343citolas
cleans85817053c_leans
clients938093clients
coagents1138443coagents
coatees93816533coate_es
coaters93525773coate_rs
coatings113811843coatings
coattends1243913coattends
codeias103911213codeias
codeinas11338013codeinas
codens94821013coden_s
contends112810573contends
contents104018213contents
copens106119963copen_s
corneas94716993corneas
coronas93916903coronas
cortinas102212423cortinas
cotans81317923cotan_s
coteau8311083cote_au
cotenant10511793cotenant
cotenants1147283cotenants
cotes76347843cote__s
cotingas11316323cotingas
cottas84615573cot_tas
covens114919263coven_s
cozens176314923cozen_s
craters95021883crate_rs
crates85736053crate__s
cratons94316033craton_s
cravens124010113craven_s
cuteness1039673cuteness
cutes79438313cute__s
cuteys11569973cute_ys
cutins83919983cutin_s
cutlas8313093cut_las
cymenes1477413cymenes
cytons111710183cyton_s
czarevnas2341353czarevnas
czarinas1935293czarinas
datchas1347423datchas
daters74827363date_rs
dates65639153date__s
daturas838763daturas
davens104612913daven_s
detents83615153detents
dracenas1145793dracenas
eaten55323053eaten__
eaters65535943eate_rs
eatings84616433eatings
etnas54713933_et_nas
extends15227113extends
extents142610173extents
faena85014203fa_ena_
fanegas1145713fanegas
farinas103215233farinas
fastens105511753fasten_s
fates85139233fate__s
fatness103311293fatness
fattens105111713fatten_s
fatwas1249053fat_was
faunas94013633fa_unas
favelas1337023favelas
fazendas2143073fazendas
galeas74618503gale_as
galena74911093galena_
gateau778103gate_au
gateaus866323gateaus
gateman1057463gateman
gaters74728633gate_rs
gates65939503gate__s
gateway1434923gateway
gateways1544603gateways
gatings95212823gatings
haptenes133810823haptenes
haptens124511343hapten_s
hastens106214813hasten_s
haters94930393hate_rs
hates86742573hate__s
havens124514043haven_s
hyaenas1334983hyaenas
hyenas1288953_hyenas
intends8239963intends
intents72115703intents
jacanas1638263jacanas
jarinas143712183jarinas
kahunas1473953kahunas
kalends1235683kalends
kanas95326913ka__nas
katas95922093kat__as
katcinas1434513katcinas
ketenes114813503ketenes
lacunas9138173lacunas
ladens74516233laden_s
lagends947273lagends
lagunas8156823lagunas
laments94314853laments
laminas93615873laminas
lantanas838263lantanas
lateens74210553lateens
laten54328343laten__
latency1236033latency
latened8711923latened
lateness82614073lateness
latent64124303laten_t
laterad8310833laterad
lateral7313563lateral
laterals8312743laterals
latests73910313latests
latexes1438313latexes
latina65621143latina_
latinos73613803latinos
latrias71913213latrias
lattens75014673latten_s
maenad939413ma_enad
maenads1037373ma_enads
magentas1137923magentas
mananas93414733mananas
manas76240423ma__nas
mannas85019803ma_nnas
marinas93519373marinas
martens93714953marten_s
maternal1047803maternal
maters85032383mate_rs
mates75251363mate__s
mateys115610943mate_ys
matinal9312603matinal
matings104516203matings
matins84527783matin_s
matzas1749703mat_zas
mavens114312973maven_s
melenas999203melenas
metepas1136303metepas
naganas847983naganas
nanas55928633na__nas
nates55238333nate__s
neatens73310403neaten_s
novenas1036893novenas
oaten55222403oaten__
oaters65029783oate_rs
ocarinas1036703ocarinas
paeans85118263pa_eans
pakehas1635313pakehas
parents93418123parents
pastinas103712153pastinas
patacas11311003patacas
patellas1039103patellas
paten74827343paten__
patency1466313patency
patent84524923paten_t
paternal1038333paternal
paters84935823pate_rs
pates76047893pate__s
patients1088763patients
patina86022193patina_
patinae95414403patinae
patines95225763patines
patins87528783patin_s
patness92912283patness
pattens95414923patten_s
platens94213983platen_s
platinas103610313platinas
ramonas9311093ramonas
ratans63819373ratan_s
ratels64518213rate_ls
raters63936573rate_rs
rates55352013rate__s
ratines75328583ratines
ratings84217403ratings
rattans73411953rattans
rattens74213403ratten_s
ravens93916883raven_s
retenes76324623retenes
retinas74819353retinas
salinas73116093salinas
santeras8311053santeras
saphenas1345713saphenas
satangs8479713satangs
sataras7315053sataras
sateens73710753sateens
sates54949323sate__s
satins64930483satin_s
saunas63915433sa_unas
scalenus1045543scalenus
scenas84114703_scenas
stenos63915773_stenos
stents65019453_stents
taenias7311283ta_enias
talents7312013talents
tartanas8258893tartanas
taters64932193tate_rs
tates55444983tate__s
tautens7317843tauten_s
tavernas11365043tavernas
teas45851493__te_as
tends65425583__tends
tenias64720073__tenias
tens45647413__ten_s
tents56434213__tents
tepas76521683__tepas
texas126514933__texas
tuateras836183tuateras
tunas54224123__tunas
vaginas11298813vaginas
varnas94212823va_rnas
veenas91410413_veenas
wakens135012043waken_s
waters95030623wate_rs
whenas124610463_whenas
yamens114010823yamen_s
zananas16319563zananas
zarebas1836303zarebas
zazens1435833zazen_s

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.1561145455.1
2DLD Change Limit1340274667.17318684.9
3Display Results4664660.3431358.6
 (SQL Overall)1786914667.67223291.3
 
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.