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

86 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
limonite104816(None) 
limonites1148001limonites
ammonite1249142ammonite
ilmenite1046222ilmenite
lignite81310302li_gnite
limonene1044572limonene
limonitic1344402limonitic
lionise7310372li_onise
lionize1668822li_onize
simonize1947812simonize
aconite9315473_aconite
alimonied1284843alimonied
alimonies1198333alimonies
ammoniate1345483ammoniate
ammonites1348143ammonites
amosite9313163_amosite
biotite9311033bi_otite
demonise11411933demonise
demonize20311533demonize
diorite8314913di_orite
disunite999313disunite
ebonite9310293_ebonite
eliminate1147733eliminate
essonite845733essonite
finite9316823fi__nite
ichnite1245983_ichnite
ignite71410583_i_gnite
ilmenites1146103ilmenites
impolite1249293_impolite
inosite7314063_inosite
iolite63221983_i_olite
ionise63516943_i_onise
ionize154613873_i_onize
ironize16610373_ironize
laborite10410703laborite
laminate103014633laminate
lemonade1144283lemonade
lemonish1347323lemonish
lemonlike1542833lemonlike
lenite6719983l__enite
leonine7311233l_eonine
licente91210893licen_te
licorice1246143licorice
lignites9129613li_gnites
limacine1246003limacine
limbate1139213lim_bate
limit73126343lim__it_
limited102310233lim__ited
limiter92710853lim__iter
limites92915453lim__ites
limits82514143lim__its
limnic10418843lim_ni_c
limning103710323lim_ning
limonenes1144983limonenes
limousine1143263limousine
lionised946603li_onised
lioniser845583li_oniser
lionises8310313li_onises
lionized1837023li_onized
lionizer1756053li_onizer
lionizes1738773li_onizes
lionlike1234983li_onlike
lipocyte1544303lipocyte
lisente71210703lisen_te
loonie64216453l_ooni_e
masonite1049683masonite
mimetite1247603mimetite
monie75631653__moni_e
monte75829773__mon_te
mylonite1346823mylonite
niobite937953ni_obite
olivenite1243563olivenite
pigeonite1244183pigeonite
pinite8321243pi__nite
pisolite10310373pisolite
rimosity1345723rimosity
saponite10410533saponite
sienite7312713si_enite
simoniac1245343simoniac
simonies10311113simonies
simonist10410723simonist
simonists1146763simonists
simonized2146523simonized
simonizes2047823simonizes
taconite1049313taconite
titanite898433titanite

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.640279204.7
2DLD Change Limit146162866.95321021.4
3Display Results86860.0461869.6
 (SQL Overall)178691867.63923391.9
 
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.