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

84 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
harmonies14131104(None) 
harmonics16107401harmonics
harmonise14148761harmonise
harmonises15148371harmonises
harmonizes24147591harmonizes
armories10313652_armories
baronies10315022bar_onies
harmines132715152harmin_es
harmonic1589432harmoni_c
harmonica16105752harmonica
harmonicas17104772harmonicas
harmonious1544172harmonious
harmonised16175392harmonised
harmonist141310662harmonist
harmonists15137122harmonists
harmonium1646082harmonium
harmoniums1744512harmoniums
harmonize23137712harmonize
harmonized25136352harmonized
harmonizer24165422harmonizer
harmonizers25133772harmonizers
hormones13311172hormon_es
inharmonies1652752inharmonies
acrimonies1445043acrimonies
agonies83016623_a_gonies
agrimonies1343413agrimonies
alimonies1198333alimonies
almonries1156933_almonries
ammonias1247953_ammonias
ammonites1348143_ammonites
argosies939523_argosies
armies85123693_arm__ies
armoires1057623_armoires
armonica1276863_armonica
armonicas13106123_armonicas
armouries1146243_armouries
astonies8815113_astonies
atonies75320953_a_tonies
balconies1347753balconies
baronnes1038553bar_onnes
brionies10310553_brionies
bryonies1336843_bryonies
carbonizes23148613carbonizes
carmines123617883carmin_es
carnies94123963car__nies
ceremonies1445783ceremonies
cronies9622513_cr_onies
daemones11209163daemon_es
daimones11208803daimon_es
disharmonies1852473disharmonies
hambones1539673hambon_es
hardies114923233har__dies
hardnoses1346233hardnoses
harlotries1345683harlotries
harmine122816193harmin_e_
harmins123716723harm__ins
harmonicist1884193harmonicist
harmony1538173harmon__y
harpies123818323har__pies
harries103525503har__ries
hegemonies1654293hegemonies
heroines112916573her_oines
heronries1248493her_onries
hominies133012953h_ominies
hormone12410503hormon_e_
hormonic1568153hormoni_c
ironies7517423_ir_onies
jargonizes2745103jargonizes
larcenies1147533larcenies
matrimonies1552963matrimonies
monies83233163___monies
palimonies1445633palimonies
parodies11313693par_odies
parsimonies1553413parsimonies
patrimonies1553693patrimonies
pharmacies1945783pharmacies
salmonids1245543salmonids
saxonies1537913sa_xonies
scammonies1643733scammonies
sermonizes21148363sermonizes
simonies10311113_simonies
stramonies1246653stramonies
warmonger1543853warmonger
warmongers1643633warmongers

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 Filter1786911486410.423422437.4
2DLD Change Limit148641846.76621968.8
3Display Results84840.0461826.1
 (SQL Overall)178691847.23524698.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.