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

170 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
camelia1151043(None) 
camelias12510301camelias
camelid1249411camelid
camellia1255441camellia
abelia83114402_abelia
bumelia1145262bumelia
cambia124913152cam_bia
camel96822802camel__
camelids1356942camelids
camellias1365092camellias
camels105217082camel_s
camera10313692came_ra
camisia112810242camisia
canella9310792canella
capelin11510972capelin
lamella988612lamella
abelian92810643_abelian
abelias93213563_abelias
abulia83512503_abulia
academia1345113academia
acedia9310393_acedia
acholia1239973acholia
aecia73819283_a_ecia
akela9311343_akel_a
alexia132910463_alexia
ameba9312383_ame_ba
amebic1239113_amebic
amentia9310153_amentia
amia66836903_am__ia
amnesia938293_amnesia
amnia75918643_am_nia
amusia839173_amusia
amylic13108713_amylic
anemia82613573_anemia
aphelia1249423aphelia
atelic8313703_atelic
babesia1146623babesia
bumelias1245063bumelias
cabala103516913cabal_a
cachexia2263583cachexia
cadelle1039923cadelle
cadenza1943773cadenza
caeca93915133ca_e_ca
caeoma1039033ca_eoma
cagelike1537723cagelike
cageling12310843cageling
calesa8412473cale_sa
calif104929103ca__lif
calix145317353ca__lix
calla74827073ca__lla
camail10314833cam_ail
camails11311753camails
cambial134010763cam_bial
cambogia1543903cambogia
cambric1537383cambric
came87648753came___
camelback2143243camelback
cameleer1246033cameleer
camelhair1651953camelhair
camellike1745063camellike
cameo95924993came__o
cameoed1238383cameoed
cameoing1379063cameoing
cameos105818003came_os
camerae11312063camerae
cameral11311283cameral
cameras11313363cameras
cames97047313came__s
camisa103114323cam_isa
camisias12268603camisias
camlet104426583cam_let
camlets114314623camlets
cammie124615293cam_mie
camorra11115763camorra
campi116217783cam_pi_
campily1638273campily
candela1089743candel_a
canellas10310563canellas
canola8313623canol_a
canula8312963canul_a
capelan1139003capelan
capelet11517073capelet
capelins12311133capelins
caplin103216303ca_plin
cardia9916373ca_rdia
carlin84421823ca_rlin
carnelian1145743carnelian
caroli85918233caroli_
carpalia1247253carpalia
caseic103212373case_ic
casein83216453case_in
caseload1145623caseload
cassia83714763ca_ssia
catalpa1136503catalpa
catamenia1344413catamenia
catena8312483cate_na
catlin83819083ca_tlin
caulis85320083ca_ulis
cavalla1257883cavalla
cavelike1738213cavelike
celiac101910433c__eliac
cella75420313c__ella
cementa112810533cementa
ceria75125353c__eria
chela103916803c_hel_a
cilia73016763c__ilia
codeia94112193code_ia
coeliac1138233c_oeliac
comedian1347453comedian
comedic14158633comedic
comelier12310653comelier
comelily1546693comelily
comely134213733comel_y
cometic131215723cometic
comitia1139723comitia
complin13312073complin
coremia11310363coremia
cumbia12379893cum_bia
cumuli1036273cumuli_
cymatia1446443cymatia
cymlin1337313cym_lin
dahlia1035773da_hlia
familial1366083familial
familiar1365953familiar
famuli1136763famuli_
favela1237033favel_a
favella1336173favella
gambia115912253gam_bia
gamelan10106643gamelan
gamelike1538033gamelike
gamely124711913gamel_y
gametic1239993gametic
ganglia946613ganglia
hamuli1137063hamuli_
harelip1245953harelip
hymenia1546393hymenia
javelin17306983javelin
javelina18315453javelina
kamala12339963kamal_a
labella988943labella
lamellae10117033lamellae
lamellar1096493lamellar
lamellas1098163lamellas
lamely114013223lamel_y
lamia75324323lam__ia
lobelia947213lobelia
mamaliga1344133mamaliga
media84721713__media
melic94722333__melic
milia72719573__milia
mycelia1444843mycelia
namely113711323namel_y
obelia8329453_obelia
paella8410913pa_ella
pallia83015593pa_llia
parhelia1346713parhelia
patella938953patella
rambla103510933rambl_a
ramekin13126493ramekin
ramenta9311183ramenta
ramilie9310283ramilie
ravelin102211023ravelin
stapelia1044673stapelia
taenia6313193ta_enia
tamein8313093tame_in
tamely113711953tamel_y
telia55821143__telia
yamalka1652963yamalka
yamulka1651773yamulka
zamia165115213zam__ia

Search took 10 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.1401276364.3
2DLD Change Limit1340271709.22014536.6
3Display Results1701700.1231382.1
 (SQL Overall)1786911709.48318843.3
 
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.