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

162 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
melamine1231030(None) 
melamines1339761melamines
calamine12314032calamine
delaine8314792dela_ine
elapine9310672_elapine
enamine91214312_enamine
etamine91313072_etamine
examine161510032_examine
gelatine93213312gelatine
hexamine2046872hexamine
ketamine14157052ketamine
melanin9310892melanin_
melanins10310382melanins
melanite10512032melanite
melanize19410302melanize
relumine1038932relumine
velamina1345662velamina
alanine7316863_alanine
alumine9412693_alumine
amine75835383___amine
beaming123618803be_aming
bedlamite1443193bedlamite
belaying143110603belaying
beltline1036943beltline
benaming1339693benaming
betaine9413783beta_ine
blaming123515693_blaming
calamined1447433calamined
calamines13312223calamines
calamint12315133calamint
calamite12312533calamite
celandine1245623celandine
ceramide1347973ceramide
defaming15238463defaming
delaines9312963dela_ines
delaminate1347373delaminate
delating103119603delating
delaying133210973delaying
deliming12310373deliming
diamine10311983_diamine
dopamine1346173dopamine
elain55324703_ela_in_
elains64919853_ela_ins
elaphine1346113_elaphine
elating83423083_elating
elative10312453_elative
enamines101112133_enamines
ermine8416923_e_rmine
etamin81311853_etamin_
etamines101611813_etamines
etamins91511833_etamins
examined18135863_examined
examinee17156583_examinee
examiner17145463_examiner
examines17128793_examines
famine114318193__famine
feline94820143fel__ine
flamines13311643_flamines
flaming134216443_flaming
flavine1338453_flavine
fulmine1257963ful_mine
gallamine1246123gallamine
gamine94620153__gamine
gelatin83514733gelatin_
gelatines102910543gelatines
gelating103015733gelating
gelatins93414093gelatins
gleaming12277933gleaming
helming133712003hel_ming
hematine131614673hematine
hexamines2146203hexamines
illumine1046083illumine
indamine1148433indamine
jessamine1892973jessamine
ketamines15177033ketamines
lamiae84817453__lamiae
lamina84920443__lamina
laminae93512973__laminae
laming94528363__laming
larine63927043__larine
lawine93316463__lawine
legatine91311403legatine
magazine2046553magazine
malaise9312673mala_ise
malamute1245893malamute
maline84529083m__aline
mamie95826003m__ami_e
marine84230403m__arine
mealie82519813me_ali_e
mealtime1245123mealtime
meanie83718393me_ani_e
meaning103918703me_aning
meclizine2244123meclizine
medaling121912263medaling
medicine1349543medicine
megadyne1542693megadyne
melamdim1242503melamdim
melamed1249633melam_ed
melange1038363mela_nge
melanian1048483melanian
melanic11310403melani_c
melanics1237733melanics
melanism1239363melanism
melanist10313053melanist
melanites11410733melanites
melanized2158573melanized
melanizes20410383melanizes
melding113414273mel_ding
melilite10410573melilite
melinite10411753melinite
melling102822623mel_ling
melodise1147593melodise
melodize2046663melodize
melting103317753mel_ting
menacing1339783menacing
menadione1243783menadione
mescaline1348943mescaline
messaline1146873messaline
metaling111613723metaling
metalise10416053metalise
metalize19414783metalize
metalline1158733metalline
metamere1257353metamere
methylamine2154253methylamine
mezzanine1942593mezzanine
milline92519113mil_line
moline84422033mol__ine
monoamine1347203monoamine
moraine9314573mora_ine
myeline1238253myel__ine
palatine10316073palatine
pelerine10313013pelerine
petaline10314883petaline
polyamine1647213polyamine
prolamine131510563prolamine
reaming103924013re_aming
reexamine1844493reexamine
relacing112516043relacing
relating92725443relating
relative11313143relative
relaxin14239183relaxin_
relaxing162612633relaxing
relaxins15248683relaxins
relaying122515153relaying
reline65434353rel__ine
relumined1245363relumined
relumines1147413relumines
reluming11310013reluming
renaming11313693renaming
rolamite1048743rolamite
seaming103222113se_aming
sepaline10311343sepaline
solanine8311533solanine
sycamine1545723sycamine
teaming103917593te_aming
telamon936523telamon_
telamones1146213telamones
thiamine1346773thiamine
tyramine1347303tyramine
velamen1237123velamen_
velarize2048763velarize
vitamine1347373vitamine

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 Filter1786911461620.436409841.7
2DLD Change Limit1461621627.64319123.6
3Display Results1621620.0762131.6
 (SQL Overall)1786911628.15521911.8
 
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.