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

168 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
calamines1331222(None) 
calamine12314031calamine_
calamined1447431calamined
calamints1348051calamints
calamites13410711calamites
alanines8314802_alanines
alumines10411682_alumines
calamint12315132calamin_t
calamite12312532calamite_
calamities1448472calamities
calcimines1674682calcimines
calcines12314752cal_cines
calumnies1346042calumnies
carabines13311472carabines
carmines123617872ca_rmines
catamites1349362catamites
flamines13311642_flamines
gallamines1345492gallamines
melamines1339762melamines
palatines11313032palatines
acarines10314343_acarines
alamodes1148013_alamodes
alanine7316863_alanine_
alanins7315803_alanin_s
alexines15258503_alexines
alines65735223_al__ines
alkines114415733_al_kines
alpines94016193_al_pines
aluminas1048353_aluminas
alumine9412693_alumine_
alumins9512983_alumin_s
amines84727983___amines
ammines11312673_a_mmines
balklines1536743balklines
balminess1356593bal_miness
caffeines1743913caffeines
caladiums1444633caladiums
calamanco1543113calamanco
calamancoes1751813calamancoes
calamancos1652273calamancos
calamander1553553calamander
calamanders1662913calamanders
calamaries1446873calamaries
calamaris1346083calamaris
calamars1238133calam_ars
calamatas1345783calamatas
calami10313423calami___
calamining1545933calamining
calamitous1443383calamitous
calamity1547753calami_ty
calamus1139243calam__us
calashes13310533cala_shes
calcimine1565413calcimine_
calcimined1762973calcimined
calcine11315273cal_cine_
calcined1338743cal_cined
calcites12313003cal_cites
calices114321693cal__ices
calkings15289223cal_kings
calkins133814873cal_kin_s
callings113613833cal_lings
calmatives1744733calmatives
calming123915973cal_min_g
calmness1236643cal_m_ness
calories102919553calori_es
calorizes202312293calorizes
calpains1239763calpain_s
calvaries1449803calvari_es
calycine1546963calycine_
calzones1948763cal_zones
camises114218463c__amises
cammies134016483ca_mmi_es
camomiles15155633camomiles
camphines1847563camphines
canakins142010463canakin_s
canalises11515493canalises
canalizes201113783canalizes
canaries10318943canari_es
canines93724033c__anines
carabine12412393carabine_
carabiner1346343carabiner
carabiners1445073carabiners
carabins12312363carabin_s
carbamides1745133carbamides
carbines123617543ca_rbines
carlines103521653ca_rlines
carmine112918483ca_rmine_
casimires1344693casimires
cassines103116613ca_ssines
catamite12510593catamite_
catmints1236663ca_tmints
cavatinas1444783cavatinas
cavatine13310323cavatine_
celandines1344843celandines
ceramides1447453ceramides
chaines124518733c_ha_ines
chamises153513313c_hamises
chlamydes2062293chlamydes
chlamyses1962493chlamyses
chloramines1845523chloramines
chlorines142512353chlorines
clamminess1643613clamminess
claries93422203c_lari_es
clarinet10317293c_larinet
clarinets1137683c_larinets
clines84926043c_l__ines
coamings13349293c_oamings
cobalamins1653223cobalamin_s
cocaines121314443coca_ines
colicines13311203colicines
columbines1643763columbines
creaminess1446203creaminess
creatines112814433creatines
culicines1347013culicines
curarines11710553curarines
cyanamides1842953cyanamides
cyanines132710543c_yanines
delaines9312963dela_ines
diamines11311643_diamines
dopamines1446043dopamines
enamines101112133_enamines
etamines101611813_etamines
examines17128793_examines
famines123216263__famines
flavines1437893_flavines
fulmines1357783ful_mines
galantines1145733galantines
galaxies1637163galaxi_es
gallamine1246123gallamine_
gamines103618463__gamines
gelatines102910533gelatines
halazones2145993halazones
harmines132715143ha_rmines
hexamines2146203hexamines
illumines1145873illumines
indamines1247553indamines
jalapins1745623jalapin_s
jasmines1736623ja_smines
kalsomines1643053kalsomines
ketamines15177033ketamines
laminas93615873__laminas
lawines103313563__lawines
magazines2145633magazines
maladies11311933maladi_es
malaises10312333mala_ises
malamutes1345373malamutes
malines93625603mal__ines
melamine12310303melamine_
nialamides1352513nialamides
paladins11911003paladin_s
palatine10316063palatine_
palominos1344063palominos
polyamines1746583polyamines
prolamines14159363prolamines
relumines1147413relumines
rolamites1148243rolamites
salamis9313513salami__s
salaries8319583salari_es
salicines11310003salicines
salines74029413sal__ines
saltines82917793sal_tines
solanines9310083solanines
sycamines1645523sycamines
telamones1146213telamones
thiamines1446383thiamines
tyramines1447213tyramines
valines104520213val__ines
vitamines1446553vitamines

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 Filter1786911486410.436409841.7
2DLD Change Limit1486411686.51622811.7
3Display Results1681680.0762210.5
 (SQL Overall)1786911687.02825425.6
 
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.