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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

197 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
harmony153817(None) 
armory114211472_armory
barony115915302bar_ony
harmin113117392harmin_
harmine122816192harmine
harming133717932harming
harmins123716722harmins
harmonic1589432harmonic
hormone12410502hormone
inharmony1751822inharmony
jargony1834492jargony
acrimony1543563acrimony
agony96415653_a_gony
agrimony1442343agrimony
alimony1236013alimony
almond91410433_almond
almondy13144483_almondy
almonry12104733_almonry
ammono1047373_ammono
among85813303_a_mong
argon65520593_argon_
argons75018203_argons
argosy1036423_argosy
arming94719803_arming
armor75118053_armo_r
armors85017813_armors
armour84411853_armour
armoury12376233_armoury
army96624183_arm__y
arrowy12288273_arrowy
arson55118833_arson_
arsons63917213_arsons
astony9510523_astony
atony87218853_a_tony
balcony1435853balcony
barman103519703barman_
barmen105418533barmen_
barmy125218763barm__y
barny105821733bar__ny
baron78131243bar_on_
barong96015823bar_ong
barons85025383bar_ons
baryon111211613baryon_
baryons121010473baryons
briony1149043_briony
bryony1435833_bryony
carbon104919043carbon_
carbons115418943carbons
carbonyl1595383carbonyl
carboy134914183carbo_y
cardon94120853cardon_
cardons104519933cardons
carman103920743carman_
carmen104019343carmen_
carmine112918483carmine
carny105822923car__ny
carroty1248943carroty
carton84522663carton_
cartons94122473cartons
cartoony13377403cartoony
ceremony1544313ceremony
charming163012033charming
charpoy1735713charpo_y
crony105918673_cr_ony
daemon9279593daemon_
daemons10269233daemons
daimon9259713daimon_
daimons10249323daimons
disharmony1952343disharmony
farming133515083farming
gammon1138903gammon_
gammons1237973gammons
garcon92912483garcon_
garcons102411643garcons
garment10315233garment
garron73113493garron_
garrons82713463garrons
hadron102913753hadron_
hadrons113314303hadrons
haemin113412663haemin_
haemins122811403haemins
haemoid1337203haemoid
hagdon1188283hagdon_
hagdons1258523hagdons
halon86124863ha_lon_
halons95720713ha_lons
hambone1439313hambone
hammily1736063hammily
hamming153014093hamming
hammock2064633hammock
hammy155113433ha_m_my
haplont12412563haplont
harbor11410723harbo_r
harbors12412413harbors
harbour1247053harbour
harden105718533harden_
hardens113815023hardens
hardily143310273hardily
hardly135112833har_dly
hardy125622063har__dy
hariana10310243hariana
haring104233003har_ing
harken135116343harken_
harkens144112863harkens
harking154120943harking
harlot94422803harlo_t
harlotry1443403harlotry
harlots103413293harlots
harm95637793harm___
harmed125218833harm_ed
harmer114719553harm_er
harmers124116593harmers
harmful1535763harmful
harmines132715143harmines
harmonica16105753harmonica
harmonics16107403harmonics
harmonies141311043harmonies
harmonise14148763harmonise
harmonist141310663harmonist
harmonium1646083harmonium
harmonize23137713harmonize
harms106829013harm__s
harpin113614383harpin_
harping134118383harping
harpins123615703harpins
harpoon1238313harpoon
harpoons1337473harpoons
harpy136418213har__py
harrow122610773harro_w
harrows132611033harrows
harry115322953har__ry
harshly1636273harshly
haymow1773683haymo_w
haymows1883813haymows
hegemony1743103hegemony
hereon93914363hereon_
heron85025503her_on_
heronry1346043her_onry
herons94820543her_ons
hominy144511483h_ominy
homonym1745253h_omonym
hormonal1346633hormonal
hormones13311163hormones
hormonic1568153hormonic
horny115619623hor__ny
irony85015903_ir_ony
jargon1448823jargon_
jargons1558203jargons
larceny1234853larceny
lardon74415063lardon_
lardons83914493lardons
lemony11419553_lemony
mammon939643mammon_
mammons1048513mammons
marmot10318743marmo_t
marmots11311513marmots
maroon83118203maroon_
maroons92615553maroons
marron83717543marron_
marrons93216973marrons
marrowy15236083marrowy
matrimony1642293matrimony
mony96830013___mony
palimony1544303palimony
pardon94618733pardon_
pardons103817623pardons
parody12410093par_ody
paronym1437503par_onym
parroty1247863parroty
parsimony1642273parsimony
parson83817903parson_
parsons93516873parsons
parton84720993parton_
partons94620513partons
patrimony1642673patrimony
pharmacy2043243pharmacy
pharming16248143pharming
ramona8412413ra_mona
salmon84614183salmon_
salmons93713263salmons
sardonyx1941453sardonyx
sarment9318763sarment
sarong73914873sar_ong
saxony1636233sa_xony
scammony1743023scammony
sermon8413553sermon_
sermons9311783sermons
shamoy14379913sha_mo_y
sharny124711833shar__ny
simony1137903_simony
stramony1344933stramony
tarpon82812803tarpon_
tarpons92612203tarpons
varment12313243varment
varmint12311683varmint
warming133515083warming
warmly14228063warm_ly

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 Filter1786911340270.1401276364.3
2DLD Change Limit1340271976.75019855.9
3Display Results1971970.0633127.0
 (SQL Overall)1786911976.95325699.8
 
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.