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

120 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
melinite1041174(None) 
melanite10512021melanite
melilite10410571melilite
melinites11310401melinites
definite1239322definite
felinity1447282felinity
gelignite1143992gelignite
meinie82614522me_ini_e
melanites11410722melanites
melanize19410302melanize
melilites1149192melilites
mylonite1346812mylonite
retinite8314852retinite
selenite81713102selenite
allanite8411093allanite
alunite7311633_alunite
belemnite1343883belemnite
celibate1259313celibate
crinite9513633_crinite
delicate11315493delicate
delimit10311733delimit_
delimited1346593delimited
delimiter1246243delimiter
delimits1137573delimits
delineate1047793delineate
ebonite9310293_ebonite
elicit8417203_elicit_
elicited1139093_elicited
elicits9311233_elicits
elint55436473_elin_t_
elints65816423_elin_ts
elite56230183_el__ite
felicity1647913felicity
feline94820143felin__e
felinities1349433felinities
felsite1039083fel_site
feminie12179933femini_e
feminine13199783feminine
feminise132010293feminise
feminity1647543feminity
feminize22199373feminize
finite9316823__finite
flinkite1543623_flinkite
galenite91210063galenite
gelidity1345573gelidity
gelignites1243583gelignites
geminate11411803geminate
heinie92512663he_ini_e
helicity1648503helicity
helictite1445973helictite
hellkite1544933hellkite
infinite1149593infinite
kainite1149543_kainite
kaolinite1344043kaolinite
kernite1159473ke_rnite
lenite6719983__lenite
lewisite1154543lewisite
lignite81310303__lignite
malignity1543653malignity
maline84529083malin__e
mannite9312903m_annite
marinate103017783marinate
masonite1049683masonite
maximite1955853maximite
meanie83718393me_ani_e
meclizine2244123meclizine
mediate103415213medi_ate
medicate13513243medicate
medicide1447713medicide
medicine1349543medicine
meditate11310623meditate
meinies92516073me_inies
melamine12310303melamine
melange1038363melan_ge
melanian1048483melanian
melanic11310403melani_c
melanics1237733melanics
melanin9310893melani_n
melanins10310383melanins
melanism1239363melanism
melanist10313053melanist
melanists1148623melanists
melanitic1346713melanitic
melanized2158573melanized
melanizes20410383melanizes
melilot9311083melilot_
melilots1046553melilots
meliorate1179483meliorate
melodise1147593melodise
melodize2046663melodize
meringue1144333meringue
mesquite19537043mesquite
mezquite28354713mezquite
militate10311673militate
minute83414293m__inute
moline84422033molin__e
mullite9313013mul_lite
multisite1147473multisite
myelinated1643343myelinated
myeline1238253myelin__e
myelinic1544243myelini_c
mylonites1446443mylonites
pelite84323003pel__ite
pinite8321243__pinite
reclinate11410023reclinate
reignite947233reignite
reincite1089703re_incite
reinvite1177753re_invite
reline65434353relin__e
relining93218743relining
resinate8316773resinate
retinites9313503retinites
reunite7312713re_unite
salinity1138893salinity
salinize1739683salinize
selenate81712523selenate
selenide9158863selenide
selenites91312083selenites
sylvinite1542923sylvinite
wellsite1145133wellsite

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 Filter1786911461620.1561145455.1
2DLD Change Limit1461621207.65619091.2
3Display Results1201200.0462608.7
 (SQL Overall)1786911207.85822740.0
 
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.