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

67 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
dopamines144604(None) 
dopamine1346171dopamine_
diamines11311642d_iamines
domaines11611062doma_ines
domines102918972do__mines
opalines10311422_opalines
amines84727983___amines
calamines13312223calamines
coamings13349293co_amings
cocaines121314443coca_ines
delaines9312963dela_ines
depaints1136643depa_ints
diamides1238823d_iamides
diamine10311983d_iamine_
diamins10312213d_iamin_s
diazines1838713d_iazines
digamies1238643digami_es
doctrines1247153doctrines
dolomites1248083dolomites
domaine10610503doma_ine_
domains10510873doma_in_s
domine92918253do__mine_
dominies113513193do__minies
dominoes11349043do__minoes
dominos103210193do__minos
donatives13146903donatives
dopants1038433dopa__nts
dopiness11289973dop__iness
dopings11408783dop__ings
dormins10311273do_rmin_s
dourines9311373do_urines
dreaminess1345313dreaminess
dynamites1544623dynamites
enamines101112133_enamines
etamines101611813_etamines
examines17128793_examines
famines123216263__famines
flamines13311643_flamines
foaminess1437503fo_aminess
gamines103618463__gamines
hexamines2146203hexamines
homines123518643ho__mines
indamines1247553indamines
ketamines15177033ketamines
loaminess1137493lo_aminess
melamines1339763melamines
monoamines1446853monoamines
moraines10314363mora_ines
oogamies1147413oogami_es
opaline9412483_opaline_
opines84820703_op__ines
oxazines2434073_oxazines
patines95225763__patines
polyamines1746583polyamines
prolamines14159363prolamines
protamines14149803protamines
rhodamines1643883rhodamines
rolamites1148243rolamites
romaines10512523roma_ines
sodamides1344653sodamides
solanines9310083solanines
sycamines1645523sycamines
thiamines1446383thiamines
topazine1944983topazine_
toplines102412563top_lines
tyramines1447213tyramines
vitamines1446553vitamines

Search took 7 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.423422437.4
2DLD Change Limit148641676.45323034.4
3Display Results67670.0135153.8
 (SQL Overall)178691676.88925938.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.