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

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

39 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
smaragdites155168(None) 
smaragdite1451901smaragdite_
smaragdes1343032smaragd__es
smaragdine1452122smaragdine_
margarites1346533_margarites
smaragde1242833smaragd__e_
smaragds1243303smaragd___s
stalagmites1451793stalagmites
andradites1244774andra_dites
aragonites1145804__aragonites
asparagines1452704asparag_ines
extradites1845574extra_dites
faradises13248984_fara_dises
faradizes22237444_fara_dizes
imparadises1653104impara_dises
malachites1785074_malachites
maladies11311934_mala_di_es
manganites1347034_manganites
marcasites1445624_marcasites
margarines1347204_margarines
margaritas1343854_margaritas
margarite1247514_margarite_
marlites103415264_mar__lites
marmites122212794_mar__mites
mirandizes2244124_mirandizes
morganites1346724_morganites
paradises122513204_para_dises
paraglides1445014_paraglides
parakites1549544_para_kites
parasites11313154_para_sites
samarskites1751204samar_skites
sardines92815564s_ar__dines
smaltites1145744sm__altites
smaragd1134394smaragd____
smarties10312874smar__ti_es
stalactites1352584stalactites
stalagmite1351984stalagmite_
umangites1244484uma_ng_ites
zaratites1847004_zara_tites

Search took 10 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 Filter1786911488190.423422437.4
2DLD Change Limit148819398.75017007.9
3Display Results39390.0301300.0
 (SQL Overall)178691399.20319416.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.