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

65 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
minacity154737(None) 
finality1448342finality
inanity1039502_inanity
megacity1645712megacity
mendacity1744152mendacity
minority1347932minority
tenacity1347112tenacity
vivacity1943992vivacity
aminity12310513amin__ity
anality10313633_anality
audacity1444823audacity
banality1338763banality
capacity1746023capacity
conicity15411093conicity
edacity1336373_edacity
feracity1646733feracity
fugacity1743313fugacity
hilarity1447173hilarity
imparity1546783imparity
incite83618733_in_cite
insanity1147333_insanity
intracity1448423_intracity
ionicity1348823ionicity
lineality1246423lineality
linearity1246113linearity
menacing1339783menacing
mendicity1745073mendicity
mentality1449133mentality
minacious1346183minacious
minacities1447993minacities
minaret9520683minaret_
minarets1048843minarets
minatory1338553minatory
mincier113512473min_cier
mincing123314333min_cing
mincy125817413min_c__y
minify1439253min__ify
minty106323903min___ty
misact10316693misac_t_
misacts1139353misac_ts
miscite11314383mi_scite
modality14117653modality
molality13118363molality
molarity13118903molarity
monacid121310243monaci_d
monacids13137513monacids
monazite1957083monazite
morality131110333morality
mordacity1743513mordacity
mundanity1543523mundanity
opacity1436313_opacity
penality13310713penality
pugnacity1742563pugnacity
rapacity1544983rapacity
sagacity1445243sagacity
salacity1347853salacity
tonality1139793tonality
tonicity1348543tonicity
venality1438683venality
veracity1647553veracity
vinosity1445733vinosity
vitality1458113vitality
voracity1645533voracity
zincify2443913zin_cify
zincite1837233zin_cite

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.453394461.4
2DLD Change Limit146162657.36019859.0
3Display Results65650.0164062.5
 (SQL Overall)178691657.82922824.2
 
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.