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

183 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
melanin931089(None) 
melanian1048481melanian
melanic11310401melanic
melanins10310381melanins
alanin6317272_alanin
elain55324702_ela_in
gelatin83514732gelatin
meanie83718392me_anie
meaning103918702me_aning
melamine12310302melamine
melange1038362melange
melanics1237732melanics
melanism1239362melanism
melanist10313052melanist
melanite10512032melanite
melanize19410302melanize
melanoid1147122melanoid
melatonin1146342melatonin
relaxin14239182relaxin
solanin7311942solanin
alanine7316863_alanine
alanins7315803_alanins
beanie83618593be_anie
beaning103820683be_aning
belaying143110603belaying
blain75421793_bla_in
celadon1036913celadon
celandine1245623celandine
ceratin93020163ceratin
cleaning113112383cleaning
cyanin113911453_cyanin
deaning94020473de_aning
delaine8314793delaine
delating103119603delating
delation92318083delation
delaying133210973delaying
deplaning1338053deplaning
detain74617383deta_in
elains64919853_elains
elan46734243_ela__n
eland65820393_elan_d
elands74914773_elands
elans55527753_elan_s
elapid939543_elapid
elapine9310673_elapine
elastin72611843_elastin
elating83423083_elating
elation73620453_elation
elfin84312463_el_fin
eloin55923203_el_oin
emplaning1446533emplaning
etamin81311853_etamin
fellahin1444513fellahin
flavin1239303_flavin
folacin1238053folacin
gelant72821673gelan_t
gelants82611443gelants
gelati73814533gelati_
gelatine93213303gelatine
gelating103015733gelating
gelatins93414093gelatins
gelation93014433gelation
gelatis83313513gelatis
gleaning10269323gleaning
guanin7610803_guanin
hematin121516023hematin
heparin12410433heparin
jalapin1645923jalapin
kelvin13117323kel_vin
keratin113314153keratin
lain46146283__la_in
lapin75222923__lapin
layin84720333__layin
leaning83721203le_aning
linin58025523__linin
main65345523m__a_in
malanga1036663malanga
malaria9313693malaria
malarian10311563malarian
malkin122913153mal_kin
manakin131810643manakin
manganin1147543manganin
mania75634153m__ania
manic94629443m__anic
matin75132853m__atin
mavin105722953m__avin
mealie82519813me_alie
mean65538093me_a__n
meaner84617843me_aner
meanies93620743me_anies
meanings11329163me_anings
meanly115412043me_anly
means75831233me_an_s
meant76537213me_an_t
meany104620483me_an_y
mechanic1747613mechanic
medaling121912263medaling
megabit12117963megabit
megahit1378773megahit
megaron10248303megaron
megaton10269853megaton
meinie82614523me_inie
melamdim1242503melamdim
melamed1249633melamed
melamines1339763melamines
melanges1138613melanges
melanisms1348653melanisms
melanists1148623melanists
melanites11410733melanites
melanitic1346713melanitic
melanized2158573melanized
melanizes20410383melanizes
melanizing2247853melanizing
melanoids1245553melanoids
melanoma1244873melanoma
melanosis1145573melanosis
melanotic1345393melanotic
melanous1048603melanous
melatonins1245643melatonins
melding113414273melding
melena81110473melen_a
melenas999203melenas
melic94722333mel__ic
melinite10411753melinite
melling102822623melling
melodia1038883melodia
melodic1238543melodic
meloid9616003mel_oid
melon73922083mel__on
melons84117713melon_s
melting103317753melting
melton8311553mel_ton
menacing1339783menacing
menazon1846053menazon
meninx1538703me__ninx
merlin83916683me_rlin
mesonic11310093mesonic
metaling111613723metaling
mezzanine1942593mezzanine
miladi938883miladi_
miladis1049823miladis
mislain9311243misla_in
moaning103714443m_oaning
mullein9278563mullein
myelin1138973myel__in
myelinic1544243myelinic
paladin101011773paladin
pelagic1237863pelagic
plain74823303_pla_in
planing103418253_planing
reagin74915533re_agin
recaning111416693recaning
regain74517763rega_in
relacing112516043relacing
relaid75518443rela_id
reland75920433relan_d
relanding112110923relanding
relands85214883relands
relating92725443relating
relation82619773relation
relaxing162612633relaxing
relaxins15248683relaxins
relaying122515153relaying
relining93218743relining
reloaning10710483reloaning
remain85919863rema_in
renin54830033re__nin
rennin63914033re_nnin
retain64523283reta_in
selenic9410663selenic
slain54923573_sla_in
solanine8311533solanine
solanins8310513solanins
telamon936523telamon
tetanic9810133tetanic
velamen1237123velamen
velamina1345663velamina
velaria1038923velaria
venin85118663ve__nin
weaning114117193we_aning
welkin1337313wel_kin
yeaning113814633ye_aning
zeatin15412823ze_atin

Search took 7 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 Limit1340271835.95322514.2
3Display Results1831830.0762407.9
 (SQL Overall)1786911836.43527768.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.