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

75 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
armonica127686(None) 
armonicas13106121armonicas
harmonica16105751harmonica
ammonia1148692ammoni_a
ammoniac1455742ammoniac
ammonic1349162ammonic_
arnica8310442ar__nica
harmonic1589432harmonic_
harmonicas17104772harmonicas
harmonics16107402harmonics
acronic112814693acronic_
acronical1347833acronical
admonish1446033admonish
aeonic83517043a_eonic_
agonic93515143a_gonic_
amanita9310453a_manita
aminic104413513a_minic_
ammoniacal1692073ammoniacal
ammoniacs1553993ammoniacs
ammonias1247953ammonias
ammonify1843353ammonify
ammonite1249143ammonite
ammonium1145883ammonium
amnia75918643a_m_ni_a
amnic95516243a_m_nic_
anionic9312873anionic_
aphonia122711883aphoni_a
aphonic142713393aphonic_
aphonics15259523aphonics
arabica1147283ar_abica
argotic10310283argotic_
arkosic1346063arkosic_
armoire938133armo_ire
armorial1049453armorial
armories10313653armories
armoring1149123armoring
arnicas939543ar__nicas
arsenic939323arsenic_
arsenical1145573arsenical
arsenics1056763arsenics
arsonist8412013arsonist
atonia63816513a_toni_a
atonic83420473a_tonic_
atonics93613713a_tonics
avionic1237693avionic_
avionics1344953avionics
axonic154312723a_xonic_
azonic175513153a_zonic_
baryonic1546203baryonic_
carbonic1439993carbonic_
cryonic1437833cryonic_
cryonics1555413cryonics
daemonic1356913daemonic_
daimonic1346603daimonic_
demoniac1346873demoniac
demonic12311223demonic_
demonical1446983demonical
erotica92811513er_otica
harmonies141311043harmonies
harmonise14148763harmonise
harmonist141310663harmonist
harmonium1646083harmonium
harmonize23137713harmonize
hormonic1568153hormonic_
ironic8313773ir_onic_
ironical1049963ir_onical
japonica19114033japonica
modica11310063__modica
parsonic1239703parsonic_
ramona8412413ramon__a
santonica1145373santonica
sardonic1147453sardonic_
sermonic1248883sermonic_
simoniac1245343simoniac
veronica1346733veronica

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 Filter1786911461620.186960704.3
2DLD Change Limit146162759.23315830.4
3Display Results75750.0332272.7
 (SQL Overall)178691759.45218905.1
 
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.