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

143 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
magenta103862(None) 
magentas1137921magentas
agenda837252_agenda
agent65829642_agent_
agents74816292_agents
magmata1237462magmata
magnet9320662magnet_
magneto1046742magneto
magnets10311142magnets
manta75629912ma__nta
maranta9311692maranta
margent10316692margent_
margents11410132margents
menta74424422m__enta
momenta11299852momenta
ramenta9311182ramenta
aceta74017353_ace_ta
agency1237033_agency
agendas936933_agendas
agene65621583_agen_e
agenes74720253_agenes
agented939433_agented
agential958153_agential
agentry11165753_agentry
agita6315423_ag_ita
ament76036543_ament_
amentia9310153_amentia
aments85219803_aments
amreeta945163amreeta
anent54931843_anent_
anta46839583_a__nta
arena55323813_aren_a
argent74023663argent_
argental947933argental
argents84014853argents
cadent94120363cadent_
cadenza1943773cadenza
catena8312483caten_a
cementa112810543cementa
coagent10313983coagent_
coagents1138453coagents
cogent9321003cogent_
egesta7428653_egesta
eugenia847713eugenia
faena85014203fa_en_a
fazenda2043253fazenda
galena74911093galen_a
genoa64315823__genoa
gent56954393__gent_
gents65729613__gents
genua64614153__genua
geta56627443__ge_ta
ingesta8357863ingesta
lagend838743lagen_d
lagends947273lagends
laguna7127223lagun_a
lament85024943lament_
laments94314853laments
latent64124303latent_
latents75214313latents
lomenta92710133lomenta
madeira1045113madeira
madonna1044403madonna
maenad939413ma_enad
mage75739133mage___
mages85036023mage__s
maggot10311713maggot_
maggots1136563maggots
maggoty1444013maggoty
magma104513583mag__ma
magnate10512703magnate
magnesia1145723magnesia
magnetic1349233magnetic
magneton1144943magneton
magnetos1146263magnetos
magnum1136733mag_num
magot8326393mag_ot_
magots9312363mag_ots
mahonia1238443mahonia
majesty1943503majesty
makuta1236393ma_kuta
malanga1036663malanga
maleate94117543maleate
mana65341963ma__n_a
manana84816073manan_a
manat76039993ma__nat
manga85026213ma__nga
mania75634153ma__nia
manna75522543ma__nna
mantas85725363ma__ntas
mantra84116093ma__ntra
mantua84412023ma__ntua
marantas10310033marantas
maremma1044463maremma
marengo1035263marengo
margented1346813margented
marina84623423marin_a
maven104816893maven__
mavens114312973maven_s
mayest114614793mayest_
melena81110473melen_a
memento11378133memento
mensa75318673m__ensa
mental84521603m__ental
meta65932413m__e_ta
misagent11410723misagent_
misagents1246793misagents
moment103319683moment_
momento11348903momento
moments113113123moments
mozetta1894753mozetta
muleta839233mule_ta
nagana748943nagan_a
omenta83411723_omenta
pageant10312783pageant_
pageants1136693pageants
parent83230423parent_
parental10310953parental
parents93418133parents
patent84524923patent_
patents94815203patents
placenta1275723placenta
polenta9310093polenta
reagent8716603reagent_
reagents959623reagents
regent74127673regent_
regental948953regental
regents83416543regents
sagest74920263sagest_
sarmenta1047723sarmenta
taenia6313193ta_enia
talent6323323talent_
talents7312013talents
tangent8315003tangent_
tangental1044783tangental
tangents938713tangents
tapeta8310693tape_ta
tegmenta1155613tegmenta
tomenta9319833tomenta
unguenta943713unguenta
urgent73816043urgent_
vagina102710933vagin_a
yenta83917043__yenta

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 Limit1340271436.87319500.5
3Display Results1431430.0463108.7
 (SQL Overall)1786911437.32524394.7
 
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.