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 “melisma” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

88 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
melisma114647(None) 
melismas1245711melismas
melismata1353102melismata
celesta947643celesta
celosia939463celosia
chrisma1456823chrisma
deism84116033de_ism_
deisms94411043de_isms
delime9314043deli_me
deliria868303deliria
delis64928543delis__
delish105215613delis_h
delist74625053delis_t
delists84414173delists
enigma935643_enigma
geisha1035213ge_isha
glioma935953_glioma
helium112311253helium_
heliums12188303heliums
helmsman1553503helmsman
holism113713753holism_
holisms123811113holisms
kelim11912553keli_m_
kelims1278913keli_ms
lima65734133__li_ma
malison939693malison
maxima17568633maxi_ma
media84721713medi__a
medina94114093medi_na
medium113711623medium_
mediums12308723mediums
medusa936293medus_a
megilla1036273megilla
melanism1239363melanism_
melanisms1348653melanisms
melanoma1244873melanoma
melds84822383melds__
melena81110473mel_ena
melic94722333meli__c
melilot9311083melilot
melismatic1654403melismatic
mells75031333mells__
melodia1038883melodia
mels65941533mel_s__
melts74930103melts__
meniscal1246203meniscal
menisci1144783menisci
mensa75318673me_ns_a
merises93421423merises
merisis93213173merisis
mesa67025483me__s_a
messman1137283me_ssman
metis75025903metis__
metisse936503metisse
miasma1097563m_iasma
milia72719573mili__a
militia949733militia
milium104712683milium_
minima105512653mini_ma
momism93410353momism_
momisms10308223momisms
monism104016313monism_
monisms113512803monisms
mulish11311903mulis_h
mutism103211463mutism_
mutisms11338453mutisms
myeloma1444043myel_oma
obelism1138203obelism_
obelisms1236393obelisms
pelisse967063pelisse
plasma103810913_plasma
realism93115923realism_
realisms102212163realisms
relish93916953relis_h
relist64628413relis_t
relists73817053relists
seism75019023se_ism_
seismal937303se_ismal
seisms84912143se_isms
seriema938403seriema
sexism15227653sexism_
sexisms16226223sexisms
talisman1045553talisman
telia55821143teli__a
telium82611393telium_
verism113214263verism_
verismo12276393verismo
verisms123011253verisms

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 Filter1786911340270.406440125.6
2DLD Change Limit134027886.57620381.2
3Display Results88880.0631396.8
 (SQL Overall)178691887.04525364.2
 
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.