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

193 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
calamine1231403(None) 
calamined1447431calamined
calamines13312211calamines
calamint12315131calamint
calamite12312531calamite
alanine7316862_alanine
alumine9412692_alumine
calami10313422calami__
calamints1348052calamints
calamites13410712calamites
calamity1547752calamity
calcimine1565412calcimine
calcine11315272cal_cine
calming123915972cal_ming
calycine1546962calycine
carabine12412382carabine
carmine112918482ca_rmine
catamite12510592catamite
cavatine13310322cavatine
gallamine1246122gallamine
melamine12310292melamine
palatine10316062palatine
acarine9316003_acarine
alamode1038153_alamode
alane56135613_ala__ne
alanin6317273_alanin_
alanines8314803_alanines
alanins7315803_alanins
alarming1138583_alarming
alexine142410543_alexine
aline57243153_al__ine
alkaline12168283_alkaline
alkine104916803_al_kine
alpine84417373_al_pine
alumin8513543_alumin_
alumina9510053_alumina
alumines10411683_alumines
alumins9512983_alumins
alvine94614583_al_vine
amine75835383___amine
ammine10314493_a_mmine
balkline1437973balkline
balsaming1445123balsaming
blaming123515693_blaming
caffeine1644513caffeine
caladium1347023caladium
calamanco1543113calamanco
calamander1553543calamander
calamar1149293calam_ar
calamari1246093calamari
calamars1238133calamars
calamary1545463calamary
calamata1247553calamata
calamining1545933calamining
calamities1448463calamities
calamus1139243calam_us
calcimined1762973calcimined
calcimines1674683calcimines
calcined1338743cal_cined
calcines12314753cal_cines
calcite11413783cal_cite
calflike1735153calflike
calkin123515493cal_kin_
calking144617783cal_king
calkins133814873cal_kins
calling103826773cal_ling
calmative1647033calmative
calorie92716883calori_e
calorize192712733calorize
calpain11310413calpain_
calpains1239763calpains
calquing2035593calquing
calumnies1346043calumnies
calumny1443863calum_ny
calving134113503cal_ving
calzone1848623cal_zone
camise103319633c__amise
cammie124615293ca_mmi_e
camomile14156323camomile
camphine1738373camphine
canakin131810833canakin_
canakins142010463canakins
canaling112016403canaling
canalise10816213canalise
canalize19914493canalize
canine83826703c__anine
caprine11314233ca_prine
carabin11313213carabin_
carabiner1346333carabiner
carabines13311463carabines
carabins12312353carabins
carbamide1645733carbamide
carbamino1545473carbamino
carbine112918643ca_rbine
carline93923613ca_rline
carmines123617863ca_rmines
caroming133312963caroming
casimire1244773casimire
cassine93817283ca_ssine
catamites1349363catamites
catmint11314463ca_tmint
cauline92215603ca_uline
cavatina1347333cavatina
celandine1245623celandine
ceramide1347963ceramide
chaine115119223c_ha_ine
chamise143612853c_hamise
chloramine1746113chloramine
chlorine133013303chlorine
claiming13279303claiming
clamant11312433c_lamant
clamlike1635163c_lamlike
clamming15329373clamming
clamping154011153c_lamping
clarinet10317293c_larinet
clawing133812673c_lawing
claying133614303c_laying
cline76428533c_l__ine
coaming123818323c_oaming
cobalamin1543503cobalamin_
cobalamins1653213cobalamins
cocaine111315173coca_ine
colicine12312993colicine
columbine1544263columbine
creaming133413143creaming
creatine103417413creatine
crimine112413473c_rimine
culicine1248343culicine
culming123811183cul_ming
curarine10610703curarine
cyanamide1743343cyanamide
cyanine122911513c_yanine
delaine8314783dela_ine
diamine10311973_diamine
dopamine1346163dopamine
elapine9310673_elapine
enamine91214303_enamine
etamine91313073_etamine
examine161510033_examine
famine114318193__famine
flamines13311633_flamines
flaming134216443_flaming
flavine1338453_flavine
fulmine1257963ful_mine
galantine1047313galantine
gallamines1345483gallamines
gamine94620153__gamine
gelatine93213303gelatine
halazone2046093halazone
harmine122816193ha_rmine
hexamine2046863hexamine
illumine1046083illumine
indamine1148413indamine
jalapin1645923jalapin_
jalapins1745623jalapins
jasmine1636643ja_smine
kalsomine1543223kalsomine
ketamine14157053ketamine
lamiae84817453__lamiae
lamina84920443__lamina
laminae93512973__laminae
laming94528363__laming
larine63927043__larine
lawine93316463__lawine
magazine2046553magazine
malaise9312673mala_ise
malamute1245893malamute
maline84529083mal__ine
melamines1339733melamines
nialamide1252763nialamide
paladin101011773paladin_
paladins11911003paladins
palatines11313023palatines
palming123914013pal_ming
palomino1246193palomino
polyamine1647193polyamine
prolamine131510553prolamine
ralline73518413ral_line
relumine1038933relumine
rolamite1048743rolamite
salaaming1265363salaaming
salami8313103salami__
salamis9313513salami_s
salicine10311703salicine
saline65132703sal__ine
saltine75018563sal_tine
solanine8311533solanine
sycamine1545723sycamine
thiamine1346753thiamine
tyramine1347303tyramine
valine94623093val__ine
velamina1345663velamina
vitamine1347373vitamine

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 Filter1786911461620.1561145455.1
2DLD Change Limit1461621939.00016240.2
3Display Results1931930.0802412.5
 (SQL Overall)1786911939.23619347.2
 
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.