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

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

192 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
magnesites13189833(None) 
magnesite12969311magnesite_
magnetites138910901magnetites
magnesias1245692magnesi_as
magnesiums1562592magnesiums
magnetises136710092magnetises
magnetite127311212magnetite_
magnetizes227910072magnetizes
amnesties1166873_amnesties
andesites1048553_andesites
anglesites1144793anglesites
madnesses1239833madnes_ses
magnates11511613magn__ates
magnesia1145723magnesi__a
magnesian1244713magnesi_an
magnesic1345753magnesi__c
magnesium1453733magnesi_um
magnetics1447163magneti_cs
magnetise125110403magnetise_
magnetised14506703magnetised
magnetisms15576693magnetisms
magnetize21519873magnetize_
magnetized23457683magnetized
magnetizer22477053magnetizer
magnetizers23544923magnetizers
magnetos1146263magne__tos
magnets10311143magne__t_s
magnifies1547283magnifi_es
majesties1845373ma_jesties
manganites1347033manganites
mannites10312613ma_n_nites
marcasites1445623marcasites
marguerites1453733marguerites
martensites1353623martensites
abnegates1244944_abnegates
adamsites1243514_adamsites
adhesives1643094_adhesives
ageists848494_ag_eist_s
agemates111110024_ag_emates
agencies1138744_agenci_es
ageneses939304_agenes__es
agenesias1045364_agenesi_as
agenesis938044_agenesi__s
agenizes18269744_ag_enizes
agentives1346444_agentives
agnates82813194_agn__ates
agnizes17328844_agn__izes
agnosias947244_agnosi_as
agnostics1244464_agnostics
agonistes10266264_agonis_tes
amnesiacs1353244_amnesiacs
amnesias1047834_amnesi_as
amnesics1255284_amnesi_cs
amnestied1263634_amnestied
amosites10311234_a_mosites
andesite949454_andesite_
andesytes1343584_andesytes
anglesite1045754anglesite_
ankerites1348524_ankerites
appetites1347514_appetites
arenites8917104_a_renites
argentites1147024argentites
arsenites9149164_arsenites
badnesses1239254badnes_ses
baguettes12115394bague_ttes
bakelites1545994ba_kelites
banksides16104854ba_nksides
bignesses1267964bignes_ses
caginesses13310944cagines_ses
campsites1546474ca_mpsites
canneries11313084canneri_es
carnotites1246544carnotites
coesites101313094__coesites
demagnetizes2552994demagnetizes
earnests837854earnes_t_s
farnesses122310814farnes_ses
fatnesses121710464fatnes_ses
gahnites1235704gahn__ites
galenites10129184ga_lenites
garnierites1252734garnierites
gaynesses1336564gaynes_ses
gestes75721394__g_es_tes
gneisses933674__gneisses
gravesites1443944gravesites
hangnests1344544hangnes_t_s
harnesses121812074harnes_ses
homesites1448914_homesites
honesties1249914_honesties
ignites81310584_ign__ites
imageries1246784imag_eri_es
inosites8312794__inosites
jadeites1645824ja_de_ites
jaggeries18136974jaggeri_es
jarosites1647374ja_rosites
kainites1238794kain__ites
lakesides1444094la_kesides
landsides11116744la_ndsides
lanosities1047914la_nosities
laterites9715054la_terites
laxnesses1646634laxnes_ses
lignites9129614lign__ites
macerates132113574ma_cerates
machetes1539634mache__tes
maderizes2148954ma_derizes
madness10310074madnes___s
magazines2145634mag_azines
magentas1137924mag_e_ntas
magister1136284mag_is_ter
magisters1235804mag_is_ters
magnate10512704magn__ate_
magnet9320664magne__t__
magnetic1349234magne__tic
magnetism14567294magneti_sm
magneto1046744magne__t_o
magneton1144944magne__ton
magnetons1244544magne_tons
magnetrons1343074magnetrons
magnificoes1971834magnificoes
magnificos1862004magnificos
magnified1645764magnifi_ed
magnifier1545274magnifi_er
magnifiers1643814magnifiers
magnitudes1443334magnitudes
magnolias1244724magnoli_as
magpies12310364mag__pi_es
mainlines1138514main_lines
makebates1744974ma_kebates
malachites1785074malachites
maleates103316344ma_le_ates
malemutes1344454ma_lemutes
malenesses12312224malenes_ses
mandates11314094ma_n_dates
maneges103612144ma_ne__ges
mangabies1446374mangabi_es
manganates1345954manganates
manganeses1345024manganes__es
manganite1247784manganite_
manginesses1499594mangines_ses
manitos9314054ma_n__itos
manitus9310924ma_n__itus
mannerisms1455014mannerisms
mannerists1245934mannerists
mannite9312904ma_n_nite_
mannoses1039084mannos__es
manses84225514ma_n_s__es
mansions1069794ma_n_sions
mantes84430784ma_n___tes
mantises10317924ma_n_tises
manumits1246004ma_numit_s
maquettes2045914maque_ttes
marbelizes2345374marbelizes
marcasite1346664marcasite_
margarites1346534margarites
marguerite1353914marguerite_
marlites103415264ma__rlites
marmites122212794ma__rmites
martensite1254414martensite_
masonites1149174ma_sonites
masteries111018494masteri_es
matelotes1146334ma_telotes
matinesses12314544matines_ses
maundies1137854maun_di_es
maximites2045314ma_ximites
mazinesses2139924mazines_ses
meannesses12128164meannes_ses
millerites1247934millerites
mimesises1345364m_imesises
mimetites1346824m_imetites
modesties1247474m_odesties
monazites2046434m_onazites
monetises11311044m_onetises
monetizes2049264m_onetizes
pansies94521984pa_n_si_es
parasites11313154pa_rasites
patnesses111611794patnes_ses
planesides1354374planesides
rawnesses1288124rawnes_ses
resites74027794___resites
sadnesses10310304sadnes_ses
sagenesses11510824sagenes_ses
smugnesses1344564smugnes_ses
synesises1245614_synesises
tangerines1147544tangerines
tanneries9310424tanneri_es
tansies74521244ta_n_si_es
umangites1244484uma_n_gites
vignettes1344674vigne_ttes
waenesses1239774waenes_ses
waggeries14127464waggeri_es
wagonettes1442914wagone_ttes
wannesses1239234wannes_ses
wernerites1344944wernerites

Search took 27 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 Filter1786911614500.1701051123.5
2DLD Change Limit16145019225.8466246.6
3Display Results1921920.406472.9
 (SQL Overall)17869119226.4226763.0
 
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.