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

194 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
canella931079(None) 
canellas10310561canellas
cadelle1039922cadelle
calla74827072ca__lla
camelia11510432camelia
camellia1255442camellia
candela1089742candela
cannula937432cannula
canola8313622can_ola
cantala94114672cantala
canula8312962can_ula
cavalla1257882cavalla
cella75420312c__ella
favella1336172favella
labella988942labella
lamella988612lamella
manilla93012472manilla
paella8410912pa_ella
patella938952patella
vanilla10238742vanilla
abelia83114403_abelia
abolla8410193_abolla
akela9311343_ake_la
anally9513503_anally
ancilla948603_ancilla
anele55628833_ane_le
aneled74719283_aneled
aneles64626293_aneles
anemia82613573_anemia
areola6813673_areola
avellan1037293_avellan
axilla13289573_axilla
banally1249223banally
barilla9310323barilla
cabala103516913ca_bala
cabbala1367183cabbala
cabrilla1245833cabrilla
cadelles1139973cadelles
cadenza1943773cadenza
caeca93915133ca_e_ca
caecal103713733ca_ecal
caeoma1039033ca_eoma
calesa8412473cale_sa
call66838673ca__ll_
callan83619603ca__llan
callas84526753ca__llas
calls75634733ca__lls
camel96822803came_l_
camelias12510303camelias
camelid1249413camelid
camellias1365093camellias
camels105217083came_ls
camera10313693came_ra
cameral11311283cameral
canaille1048413canaille
canal75428043can_al_
canaled103615563canaled
canalled1139583canalled
canaller1038953canaller
canals84421663can_als
canasta938363canasta
cancel105316683cancel_
canceled13279403canceled
canceler12238913canceler
cancelled1456743cancelled
canceller1366683canceller
cancels114113313cancels
cancha134411613can_cha
candelas1139533candelas
candida114110253candida
candle94321483can_dle
candled113815743candled
candler103516593candler
candles104422343candles
cane66653123cane___
caned85838093cane__d
caner75334773cane__r
caners84629203cane_rs
canes75350373cane__s
canful11610263canful_
canfuls1248423canfuls
canna75919333can__na
cannel84216403cannel_
cannelon1045123cannelon
cannels93413363cannels
cannily1239263cannily
cannoli937263cannoli
cannulae1046493cannulae
cannular1046283cannular
cannulas1037583cannulas
canolas9313993canolas
cantal84122033cantal_
cantalas104013523cantalas
cantals93919573cantals
cantata93811813cantata
canthal12410053canthal
cantina93417253cantina
cantle84522153can_tle
cantles94721413cantles
canulae9311183canulae
canular9310323canular
canulas9312853canulas
canzona1836073canzona
capelan1139003capelan
capelet11517073capelet
capelin11510973capelin
capitella1342613capitella
carnally1339513carnally
carnelian1145743carnelian
carrell94610473carrell_
carrells10359273carrells
caseload1145623caseload
castellan1144353castellan
catalpa1136503catalpa
catena8312483cate_na
cavallas1366843cavallas
cavally1588483cavally
cedilla1036343cedilla
cell65031723c__ell_
cellae84915933c__ellae
cellar84514983c__ellar
celli76717693c__elli
cello74919583c__ello
cells75428063c__ells
challa114014193c_halla
chandelle1545223chandelle
chela103916803c_he_la
cholla113911023c_holla
cinema1047653cine_ma
cineol8108203cineol_
cineole91010003cineole
cineols9128853cineols
cingula10327173cingula
clitella1043673clitella
conelrad1145603conelrad
corolla938623corolla
crenelle1046333crenelle
cruelly1236563cruelly
cubanelle1372483cubanelle
cuneal8611513cuneal_
fanega1055783fane_ga
favela1237033fave_la
favellas1446163favellas
fella84918653__fella
flabella1344963flabella
flagella1244563flagella
gabelle10259213gabelle
ganglia946613ganglia
gazelle17236333gazelle
glabella1144273glabella
hazelly2254383hazelly
knell94210923_knell_
knells10439253_knells
lamellae10117033lamellae
lamellar1096493lamellar
lamellas1098163lamellas
lanely93914483lane_ly
latilla737953latilla
mandala10310213mandala
mandola1039023mandola
manila84518303man_ila
manillas102611163manillas
manille92613273manille
mantilla1048163mantilla
maxilla16248193maxilla
micella11106823micella
nacelle938153nacelle
nelly84618813__nelly
nigella844523nigella
novella1076213novella
paellas9411413pa_ellas
panatella1143803panatella
panel76023623pane_l_
paneled10612573paneled
panelled1138963panelled
panels84716523pane_ls
panetela1044143panetela
panetella1143403panetella
papilla11127913papilla
patellae1047623patellae
patellar1046863patellar
patellas1039103patellas
prunella1044073prunella
quinella1744043quinella
ranula6311813ran_ula
ravelly13268353ravelly
rubella9146523rubella
sanely93114613sane_ly
scutella1043553scutella
snell54517303_snell_
snells64614203_snells
stella63612973_stella
vanillas11228123vanillas
walla85321033wa__lla

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.406440125.6
2DLD Change Limit1340271946.53020524.8
3Display Results1941940.0802425.0
 (SQL Overall)1786911947.01625469.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.