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

419 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
carinae9431858(None) 
carina84325321carina_
carinal94318221carinal
carinas93622381carinas
carinate103320241carinate
acarine9316002acarin_e
canine83826702canin_e
caprine11314232caprin_e
carbine112918642carbin_e
cardiae10713702cardiae
cardinal1139552cardinal
caribe103416752cari_be
carinated123414262carinated
caring95137992carin_g
cariole9818342cariole
caritas93316942caritas
carline93923612carlin_e
carmine112918482carmin_e
carnage10311742car_nage
carnal83919202car_nal
carnie84421092car_nie
catenae9311362catenae
coronae94214892coronae
cringe93515482c_ringe
curiae84518372curi_ae
czarina1845952czarina_
czarinas1935292czarinas
farina94618232farina_
farinas103215232farinas
jarina134014062jarina_
jarinas143712182jarinas
laminae93512972laminae
larine63927042larin_e
marina84623412marina_
marinade11259382marinade
marinas93519372marinas
marinate103017782marinate
marine84230402marin_e
narine63422552narin_e
ocarina948022ocarina_
ocarinas1036702ocarinas
patinae95414402patinae
sarcinae1047192sarcinae
vaginae11377682vaginae
acaridan1165233acaridan
acarines10314343acarines
acinar8310483_acinar
actinal9312293actinal
actiniae101810013actiniae
aline57243153_alin_e
amine75835383_amin_e
arcane81216743_arcane
areae55229743_ar_eae
arena55323813_arena_
arenas65021993_arenas
arene55329413_aren_e
arginase946433_arginase
aria46245423_ari_a_
arias55438023_ari_as
ariose64818723_ariose
arise56436433_ari_se
aristae7312523_aristae
arsine64021043_arsin_e
azine146721413_azin_e
badinage1294923badinage
baring95135853barin_g
barite84224813bari_te
baronage1147073baronage
baronne938263baronne
basinal9310033basinal
brine75132273_brin_e
cabana103913563cabana_
cabanas112413033cabanas
cabin94820943cabin__
cabined1239993cabined
cabinet11318903cabinet
cabinmate1544093cabinmate
cabins104418923cabin_s
cabriole1276933cabriole
cacique20205693cacique
cadence1239063cadence
caging105321023cagin_g
caiman103615663ca_iman
cain65643913ca_in__
cains75334303ca_in_s
caique17318803ca_ique
cairn75717513cairn__
cairned1037643cairned
cairns85313303cairn_s
cairny11557823cairn_y
caking134624673cakin_g
calcine11315273calcin_e
calibre1136603calibre
caliche14329953caliche
calicle113111433calicle
califate13310483califate
calipee11412913calipee
camerae11312043camerae
camisa103114323camisa_
camisade1374823camisade
camisas113411923camisas
camise103319633cami_se
canal75428043ca__nal
canape10913513ca__nape
cane66653113ca__n_e
canines93724033canines
caning94128623canin_g
canna75919333ca_nna_
cannas84518403ca_nnas
cannie83819363ca_nnie
canoe75627253ca__noe
cantina93417253cantina_
cantinas102713773cantinas
canulae9311183canulae
capias10318353capi_as
capita102913773capita_
capital112311523capital
capitate121712183capitate
caprice1349683capri_ce
capriole1276913capriole
carabao1139673carabao
carabine12412383carabin_e
caracal11312513caracal
carafe115416163car_afe
carapace1446083carapace
carapax1835793carapax
carat75048793car__at
carate84734003car_ate
caravan1239223caravan
caraway1538133caraway
carbide126112493carbide
carbineer1344753carbineer
carbines123617533carbines
carbinol1245773carbinol
carbonade1446543carbonade
carbonate13410513carbonate
carcanet12316343carcanet
carcase11312733carcase
cardcase1345963cardcase
cardia9916373cardia_
cardiac1278813cardiac
cardias10715093cardias
cardigan1245613cardigan
cardinals1247983cardinals
carding113922433cardin_g
cardings123812623cardings
care66968373car___e
caretake1446773caretake
carfare12310073carfare
caribes113715643caribes
caribou1156993caribou
carices114220953carices
caried94528693cari_ed
caries85147623cari_es
carioca1139683carioca
cariocas1239663cariocas
carioles10817063carioles
carious93320283carious
caritases1139743caritases
carking144322853carkin_g
carle74535703car__le
carlin84421823carlin__
carlines103521643carlines
carling103727063carlin_g
carlings114015853carlings
carlins93921913carlin_s
carload1039783carload
carman103920743car_man
carmines123617863carmines
carn66245433car_n__
carnages11312213car_nages
carnet84732873car_net
carney115315703car_ney
carnies94123963carnies
carnify1555883carnify
carnival1345613carnival
carns75937563car_n_s
carny105822923car_n_y
caroche1469243caroche
carouse9614423carouse
carpal103716253car_pal
carpale113414353carpale
carping123521083carpin_g
carpings133812383carpings
carriage1137853carriage
carriole1089863carriole
carronade1246093carronade
carse74934333car__se
cartage10312593cartage
carte75940423car__te
cartilage1245533cartilage
carting104228283cartin_g
caruncle1244713caruncle
carve106227753car__ve
carving133916773carvin_g
carvings143810203carvings
caseinate1148243caseinate
casing94829103casin_g
casings104013513casings
casini84615863casin_i
casino84317553casin_o
casinos93512833casinos
casita82913703casita_
casitas93312043casitas
cassina94113163cassina_
cassinas103610633cassinas
cassine93817283cassin_e
catena8312473catena_
catenas9313103catenas
catenate10312833catenate
catkinate1545823catkinate
catnap1098383ca_tnap
cauline92215603caulin_e
caviar11310163cavi_ar
caviare1238373caviare
cavie104621593cavi__e
caving124822613cavin_g
cavings134712543cavings
cavitate13159833cavitate
cawing124322613cawin_g
cayenne1244603cayenne
cazique27194033cazique
ceria75125353ceri_a_
cerias83321973ceri_as
cering94522533cerin_g
cerise84822043ceri_se
cerite84724873ceri_te
cervine122610803cervin_e
chaine115119223chain_e
charing133721323charin_g
china105022473c_hina_
chinas115119383c_hinas
chine105231723c_hin_e
choanae1236863choanae
chorine123218363chorin_e
cine66242943c__in_e
circinate1347813circinate
citrine92514023citrin_e
clarence1246443clarence
clarinet10317293clarinet
clinal8311553c_linal
cline76428533c_lin_e
cnidae978143c_nidae
coinage10310553c_oinage
conine84528553conin_e
coprince1447093coprince
corbina111911443corbina_
corbinas12229383corbinas
coria75828303cori_a_
coring94433963corin_g
cornea84018923cor_nea
cornice11612933cornice
corona83817403corona_
coronal94115763coronal
coronas93916903coronas
coronate103018213coronate
cortina91915963cortina_
cortinas102212423cortinas
corvina12229493corvina_
corvinas13238003corvinas
corvine122113643corvin_e
cosine83823513cosin_e
crane75331603c_ran_e
crania82418433crania_
cranial92114683cranial
craniate10312563craniate
crenate93317113c_renate
crime94822693c_ri_me
cringed113312403c_ringed
cringer103514243c_ringer
cringes103215503c_ringes
cringle103010353c_ringle
crinite9513633c_rinite
crinkle13359413c_rinkle
crinum1039333c_rinum
cripe95521143c_ri_pe
cristae9310603c_ristae
crone75231333c_ron_e
curarine10610703curarin_e
curia74523763curi_a_
curial84019153curi_al
curie74533033curi__e
curing94824783curin_g
curite85222943curi_te
cyanine122911513cyanin_e
daring84928683darin_g
darings93713643darings
dariole8711163dariole
drainage1045783drainage
earing75235483earin_g
earings84517703earings
eccrine1137283eccrin_e
faciae112913413faci_ae
famine114318193famin_e
faring105231283farin_g
farinha13357063farinha
farinhas14325363farinhas
farinose1136463farinose
faunae95210373fa_unae
feriae95618603feri_ae
ferine96422583ferin_e
fringe104013953_fringe
gamine94620153gamin_e
garigue935583garigue
hariana10310243hariana
harianas1139163harianas
harijan1735783harijan
haring104233003harin_g
harmine122816193harmin_e
herniae1039043herniae
lacunae9116803lacunae
lamiae84817453lami_ae
lamina84920443lamina_
laminal94113633laminal
laminar93810283laminar
laminas93615873laminas
laminate103014633laminate
lariat6629043lari_at
larvae938843lar_vae
latina65621143latina_
latinas74416463latinas
latrine7715123latrin_e
lawine93316463lawin_e
loricae938253loricae
maline84529083malin_e
marginal1137603marginal
marginate12179603marginate
maria75032883mari_a_
marinaded13276533marinaded
marinades12268973marinades
marinara1046493marinara
marinated122513173marinated
marinates112516383marinates
mariner93315993mariner
marines93928013marines
marital92314183marital
marline93320953marlin_e
matinal9312603matinal
matinee92415613matinee
minae75627723__minae
murine84220023murin_e
nardine82712573nardin_e
narial6317953nari_al
oaring74225303oarin_g
paginal10269493paginal
paginate114012443paginate
parae76335703par__ae
pardine103616723pardin_e
pariah114320583pari_ah
parian83223963pari_an
parians93519733parians
paring94236493parin_g
parings104219213parings
patina86022193patina_
patinaed11407833patinaed
patinas96318523patinas
patinate103016313patinate
patine85328123patin_e
perinea9313033perinea
prince104114763_prince
purine85321893purin_e
rapine85023083rapin_e
raring74332873rarin_g
ratine65131823ratin_e
ravine95522223ravin_e
reginae84713453reginae
retinae75517333retinae
rinse54820973__rinse
sabine84020393sabin_e
salina64221123salina_
salinas73116093salinas
saline65132703salin_e
sarcina9310733sarcina_
sarcinas1039273sarcinas
sardine83317393sardin_e
sarin55239253sarin__
sarins63932623sarin_s
savine94220283savin_e
scaring103421973scarin_g
scariose1037593scariose
scoriae9310893scori_ae
serine65432673serin_e
shrine94920053shrin_e
springe103913983springe
striae65422273stri_ae
syringe11349473syringe
tacrine9311293tacrin_e
taeniae739083taeniae
taring73932283tarin_g
tarnal63716503tar_nal
taurine7311363taurin_e
trainee72817793trainee
trinal6516953_trinal
trine54734603_trin_e
tsarina736653tsarina_
tsarinas835273tsarinas
tzarina1635053tzarina_
tzarinas1733973tzarinas
urinal6614123_urinal
urinate7315363_urinate
urine55026593_urin_e
vagina102710933vagina_
vaginal11288403vaginal
vaginas11298813vaginas
vaginate123911083vaginate
vahine123612113vahin_e
valine94623093valin_e
varia85824203vari_a_
variance1397413variance
variant10316803variant
varias95019903vari_as
variate101316433variate
variole10711593variole
varna84516173var_na_
varnas94212823var_nas
wahine123813013wahin_e
waring105029443warin_g
zariba1736983zariba_
zaribas1836043zaribas

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 Filter1786911340270.1601116818.8
2DLD Change Limit1340274198.35616039.6
3Display Results4194190.1432930.1
 (SQL Overall)1786914198.65920636.4
 
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.