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

103 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
melilites114919(None) 
melilite10410571melilite_
melinites11310401melinites
melanites11410722melanites
melilots1046552melilot_s
melinite10411742melinite_
mullites10411642mul_lites
aerolites9312583aerolites
bellies94023723bel_li_es
beltlines1135963beltlines
celibates1358633celibates
cellulites1294433cellulites
debilities13411293debilities
deciliter1247033deciliter
deciliters1345173deciliters
decilitres1344993decilitres
delicates12314313delicates
delimited1346593delimited
delimiter1246243delimiter
delimiters1345103delimiters
delimits1137573delimit_s
dellies83622213del_li_es
depilates12310923depilates
egalites9310503_egalites
elicited1139093_elicited
elicits9311233_elicit_s
elites66027123_e__lites
epilates10313503_epilates
felicities1549743felicities
felinities1349433felinities
fellates11312753fel_lates
fellies104119743fel_li_es
felsites1138073fel_sites
gelidities1247203gelidities
gelignites1243583gelignites
helicities1549853helicities
heliclines1544043heliclines
helictites1544653helictites
helilifted1752133helilifted
helilifts1542373helilifts
hellkites1644633hellkites
illites72415013_il_lites
jellies143816533jel_li_es
kellies113516853kel_li_es
lewisites1244213lewisites
lilies63021413__lili_es
limites92915453__limites
marlites103415263m_arlites
maximites2045313maximites
mealies92821933me_ali_es
meclizines2342363meclizines
medflies1435553medfli_es
mediates112814063medi_ates
medicates14312113medicates
medicides1556583medicides
medicines1447903medicines
meditates1239813meditates
megaliths1544743megaliths
meinies92516073me_ini_es
melamines1339763melamines
melanite10512023melanite_
melanizes20410383melanizes
melilot9311083melilot__
meliorates1288903meliorates
melodies11310123melodi_es
melodises1247603melodises
melodizes2146753melodizes
mesquites20476433mesquites
metalises11315073metalises
metalizes20414243metalizes
mezquites29374023mezquites
militates11310883militates
milliliter1243623milliliter
milliliters1353043milliliters
millimes122411373mil_limes
millines102718063mil_lines
mobilises1347513mobilises
mobilities1449833mobilities
mobilizes2247423mobilizes
molalities121110283molalities
mollies93420233mol_li_es
motilities12410583motilities
mullite9313013mul_lite_
mutilates11310953mutilates
myelitides1642813myelitides
mylonites1446443mylonites
nellies73418723nel_li_es
pearlites1138233pearlites
pelites93821993pe__lites
penlites10312273pe_nlites
perlites10316363pe_rlites
retinites9313503retinites
selenites91312083selenites
senilities10312993senilities
sepiolites1246013sepiolites
stellites938123stel_lites
tellies73820503tel_li_es
tillites8312833til_lites
troilites948433troilites
velites103417303ve__lites
wellies103719073wel_li_es
wellsites1244673wellsites
zeolites1738383ze_olites

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 Filter1786911486410.420425454.8
2DLD Change Limit1486411037.56319653.7
3Display Results1031030.0462239.1
 (SQL Overall)1786911038.02922255.7
 
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.