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

95 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
magnetic134923(None) 
magnesic1345751magnesic
magnetics1447161magnetics
agenetic1138202_agenetic
agnatic10310972_agnatic
magmatic1548402magmatic
magnesia1145722magnesia
magnet9320662magnet__
magnetise125110402magnetise
magnetism14567292magnetism
magnetite127311212magnetite
magnetize21519872magnetize
magneto1046742magnet_o
magneton1144942magneton
magnetos1146262magnetos
magnets10311142magnet_s
magnific1654212magnific
mannitic1248012mannitic
mantic104120902ma_n_tic
acetic10314503_a_cetic
agnostic1146713_agnostic
agrestic1147923_agrestic
akinetic1455953akinetic
aloetic9313183_aloetic
amnesic1137183_amnesic
amnestic1247053_amnestic
anemic102713693_a_nemic
angelic1039623_angelic
antic75728863_a_n_tic
aphetic142912853_aphetic
apneic1078623_apne_ic
argentic1149023argentic
ascetic11310063_ascetic
atretic9313923_atretic
auxetic1637143_auxetic
balletic1248073balletic
bathetic1548583bathetic
cantic103920543ca_n_tic
diagenetic1454253diagenetic
diamagnetic1752943diamagnetic
digenetic1345353digenetic
fanatic12610703fa_natic
frenetic1346293frenetic
gametic12310003ga_metic
genetic101211783_genetic
geomagnetic1753373geomagnetic
imagistic1445113imagistic
kinetic13209173_kinetic
lignitic1146393lignitic
limnetic1255583limnetic
maenadic1344613maenadic
magenta1038623magent_a
magentas1137923magentas
magic105818663mag___ic
magnate10512703magnat_e
magnates11511613magnates
magnesian1244713magnesian
magnesias1245693magnesias
magnesite12969313magnesite
magnesium1453733magnesium
magnetised14506703magnetised
magnetises136710093magnetises
magnetisms15576693magnetisms
magnetites138910903magnetites
magnetized23457683magnetized
magnetizer22477053magnetizer
magnetizes227910073magnetizes
magnetons1244543magnetons
magnetron1243273magnetron
magnifico1762573magnifico
magnolia1144793magnolia
maieutic1243873maieutic
majestic1944913majestic
malefic1486323ma_lefic
manganic1346993manganic
manic94629443ma_n__ic
mantid93820383ma_n_tid
mantis83926033ma_n_tis
mantric11311353ma_ntric
marlitic1238343marlitic
mastic103119173ma__stic
mastitic1248263mastitic
metagenetic1654293metagenetic
mimetic1338653m_imetic
nonmagnetic1654133nonmagnetic
oogenetic1255493oogenetic
pangenetic1554713pangenetic
paretic113016673pa_retic
pathetic15410963pathetic
phenetic1549203phenetic
phonetic15310323phonetic
rabietic1245503rabietic
tabetic1138463ta_betic
tagmemic1542713tagmemic
tonetic9313433_tonetic

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.406440125.6
2DLD Change Limit146162957.28020077.2
3Display Results95950.0462065.2
 (SQL Overall)178691957.73223110.6
 
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.