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

122 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
paronym143750(None) 
paronyms1546551paronyms
acronym1445672acronym
anonym1136382_anonym
barony115915302barony_
caconym1644952caconym
parody12410092parody_
paronymic1845372paronymic
paroxysm2242732paroxysm
acronyms1544993acronyms
agony96415653_agony_
allonym1244733allonym
anonyms1235443_anonyms
antonym1246513antonym
apron7318833apron__
aproned10311503aproned
aprons8316993apron_s
aroynt9312893_aroynt
atony87218853_atony_
autonym1246633autonym
barny105821733bar_ny_
baron78131243baron__
baronet91022213baronet
barong96015823baron_g
barongs105310833barongs
baronne938273baronne
barons85025383baron_s
caconyms1744003caconyms
caconymy2042773caconymy
carbonyl1595383carbonyl
carny105822923car_ny_
carom95025563caro__m
crony105918673_crony_
eponym1345793_eponym
exonym1844583_exonym
harmony1538173harmony_
homonym1745253homonym
hyponym2044423hyponym
irony85015903_irony_
jargony1834493jargony_
metonym1445573metonym
padrone102512073padron_e
padrones112711043padrones
padroni10278613padron_i
padronism1445503padronism
paeon74819493paeon__
paeons83915523paeon_s
parang93715513paran_g
parangs104314373parangs
paranymph2152083paranymph
pardner10239473pardner
pardon94618733pardon__
pardoned12189333pardoned
pardoner11189443pardoner
pardons103817623pardon_s
pardy115523953par_dy_
parent83230423paren_t
parents93418123parents
paring94236493parin_g
parings104219213parings
parity114719873parity_
parlay113713993parlay_
parlays123910453parlays
parley116718363parley_
parleys125212373parleys
parodic122311723parodic
parodoi10267723parodoi
parodos103011753parodos
parol74826273paro__l
parole84425253paro_le
paroled104217633paroled
parolee94119653parolee
paroles95025883paroles
parols84722613paro_ls
paronymous1762993paronymous
parotic112518043parotic
parotid102915513parotid
parous84024163paro_us
paroxysms2342573paroxysms
parroty1247863parroty_
parry105323753par_ry_
parsnip1146323parsnip
parson83817903parson__
parsonic1239703parsonic
parsons93516873parson_s
partly116315473partly_
partner92811393partner
parton84720993parton__
partons94620513parton_s
party106630613par_ty_
patron84018043patron__
patronal1048653patronal
patronly1344883patronly
patrons93818103patron_s
patronymic1953813patronymic
paynim1337363pa_ynim
peony105717563p_eony_
peroxy1838253peroxy_
phony136715443p_hony_
pony96434053p__ony_
porny106020193por_ny_
proem94818273p_ro_em
prom87631703p_ro__m
prone75332623p_ron_e
prong85218113p_ron_g
prongs94314483p_rongs
pronto8313993p_ronto
propyl13358183p_ropyl
prosy106319253p_rosy_
protyl11308213p_rotyl
proxy175011013p_roxy_
pyrone112714473pyron_e
pyrones123113303pyrones
retronym1354683retronym
sardonyx1941453sardonyx
sarong73914873saron_g
sarongs84511803sarongs
saxony1636233saxony_
synonym1544073synonym
tautonym1342983tautonym
toponym1445163toponym
varoom11411413varo_om

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 Filter1786911340270.406440125.6
2DLD Change Limit1340271227.09318895.7
3Display Results1221220.0462652.2
 (SQL Overall)1786911227.54523683.4
 
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.