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

124 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
parsonic123970(None) 
arsenic939322_arsenic
baryonic1546202baryonic
carbonic1439992carbonic
harmonic1589432harmonic
masonic1139912ma_sonic
paranoic1249832paranoic
parodic122311722par_odic
parotic112518042par_otic
parsnip1146322pars_nip
parson83817902parson__
parsonish1446322parsonish
parsons93516872parson_s
pharaonic1645762pharaonic
sardonic1147452sardonic
acronic112814693_acronic
aeonic83517043_a_eonic
agonic93515143_a_gonic
ammonic1349163_ammonic
anionic9312873_anionic
aphonic142713393_aphonic
aprotic112715243apr_otic
argotic10310283_argotic
arkosic1346063_arkosic
armonica1276863_armonica
arsenics1056763_arsenics
arson55118833_arson__
arsonist8412013_arsonist
arsons63917213_arson_s
atonic83420473_a_tonic
avionic1237693_avionic
axonic154312723_a_xonic
azonic175513153_a_zonic
boronic11311163bor_onic
bosonic1139213_bosonic
canonic11312933ca_nonic
carbolic1448323carbolic
cationic12310013cationic
chronic14311423chr_onic
cratonic1239123cratonic
cryonic1437833_cryonic
daemonic1356913daemonic
daimonic1346603daimonic
daltonic1146523daltonic
draconic1346203draconic
hadronic1447953hadronic
harmonica16105753harmonica
harmonics16107403harmonics
hormonic1568153hormonic
hypersonic2087143hypersonic
ironic8313773_ir_onic
kaonic1238763ka__onic
karstic1357983kars_tic
laconic1139883la_conic
lactonic1248053lactonic
mesonic11310093_mesonic
moronic11311863mor_onic
narcotic1277913narcotic
opsonic1137253_opsonic
padroni10278613padroni_
paesani9348683paesani_
panic93923903pa___nic
pansophic1853493pansophic
parabolic1546283parabolic
paranoia10410573paranoia
paranoiac1346273paranoiac
paranoics1347663paranoics
paranoid11311143paranoid
parasitic1349523parasitic
parboil1138323parbo_il
pardon94618733pardon__
pardoned12189333pardoned
pardoner11189443pardoner
pardoning1338763pardoning
pardons103817623pardon_s
paregoric1444673paregoric
paretic113016673par_etic
parhelic1547093parhelic
paronym1437503par_onym
paronymic1845373par_onymic
parosmia1245953parosmia
parotid102915513par_otid
parsec105914483pars__ec
parsing103819553parsin_g
parsnips1245533pars_nips
parsonage12225583parsonage
parton84720993parton__
partons94620513parton_s
parvolin1376933parvolin
patriotic13107593patriotic
peptonic1448833peptonic
periodic1348433periodic
periotic12313443periotic
person83517873person__
persona92812453person_a
personae102410553personae
personal102311573personal
personas102511883personas
personify1744013personify
persons93717013person_s
phonic133315213p__honic
photonic15312103photonic
phrenic1438773phr_enic
phytonic1848203phytonic
pionic103515953p__ionic
platonic1238773platonic
pleonic1139433p_leonic
plutonic1246103plutonic
podsolic1344173podsolic
prosaic11311163p_rosaic
prosodic1347693prosodic
protonic12314593protonic
pulmonic1445033pulmonic
puranic11410483pur_anic
pyrrolic1544563pyrrolic
pythonic1847553pythonic
sermonic1248883sermonic
sonic75225293___sonic
subsonic1245753subsonic
supersonic1447403supersonic
telsonic1045993telsonic
transonic1146163transonic
tyronic1239313tyr_onic
zirconic2144013zirconic

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.470380193.6
2DLD Change Limit1461621247.42019698.4
3Display Results1241240.0631968.3
 (SQL Overall)1786911247.95322468.4
 
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.