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

218 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
margents1141013(None) 
argents84014851_argents
margent10316691margent_
agents74816292_a_gents
argent74023662_argent_
arpents93613082_arpents
emergents1245972emergents
gargets94614572garge_ts
garments1139962garments
magenta1038622ma_genta
magentas1137922ma_gentas
magnets10311142ma_gnets
margented1346812margented
marges94525712marge__s
margins103815192margin_s
markets133314032marke_ts
martens93714952marten_s
mordents1138812mordents
morgens10310462morgen_s
parents93418122par_ents
pargets105215192parge_ts
sarments10311962sarments
tangents938712tangents
targets84314222targe_ts
varments1339062varments
absents93510723_absents
accents113511233_accents
advents11309473_advents
agenes74720253_a_genes
agent65829643_a_gent_
ambients1246053ambients
aments85219803_a_ments
ardent73022613_ardent_
arenas65021993_ar_enas
arenes64928393_ar_enes
argental947933_argental
argentic1149023_argentic
argentous1045603_argentous
argentum1145363_argentum
argentums1243873_argentums
argons75018203_argon_s
argots74116033_arg_ots
arguments1256573_arguments
armets84918353_arme_ts
aroints7313133_aroints
aroynts1036633_aroynts
arpens84814823_arpen_s
arpent84822093_arpent_
arrests73312683_arrests
ascents93812553_ascents
assents74512223_assents
augends935883_augends
augments1137833_augments
barbets114915843barbe_ts
bargees105415873barge_es
barges94528253barge__s
barghests1543313barghests
barguests1243483barguests
baronets101410903baronets
barrens94414323barren_s
barrets94917103barre_ts
bartends1136793bartends
brents84717273_br_ents
careens94514703careen_s
carets85330773car_e_ts
carnets93918403carne_ts
carpets113915333carpe_ts
coagents1138453coagents
currents1038373currents
darkens12409873darken_s
dragnets10136563dragnets
earnests837853earnests
emergent1149113emergent_
ferments13311473ferments
forgets113813793forge_ts
fragments1546213fragments
gadgets10348683gadge_ts
gardens93312093garden_s
garget84327273garge_t_
gargety12388043garge_ty
garment10315233garment_
garnets84115403garne_ts
garrets84413623garre_ts
gents65729613___gents
gerents82612923ger_ents
gorgets94711783gorge_ts
hardens113815023harden_s
harkens144112863harken_s
harvests14246173harvests
imarets9138643imar_e_ts
jargons1558203jargon_s
lagends947273la_gends
laments94314853la_ments
largeness1038273largeness
larges74824233large__s
largess8408913large_ss
largest83715103largest_
latents75214313la_tents
maddens11359753madden_s
mages85036023ma_ge__s
maggots1136563ma_ggots
magnet9320663ma_gnet_
magneto1046743ma_gneto
magnetos1146263ma_gnetos
magots9312363ma_g_ots
maidens10349663maiden_s
mallets93318493malle_ts
mammets103911113mamme_ts
mangels103614493mange_ls
mangers103521263mange_rs
manges94628943mange__s
manhunts1344043manhunts
maranta9311693mar_anta
marantas10310023mar_antas
marcels113212373marce_ls
marengo1035263mar_engo
mares76457633mar_e__s
margays1337493marg_ays
marge85328333marge___
margenting1446153margenting
margin94016843margin__
marginal1137603marginal
marginals1246003marginals
marginate12179603marginate
marginates13168743marginates
margined1237743margined
marinas93519383mar_inas
mariners103113863mariners
marines93928013mar_ines
markers133516103marke_rs
market123226043marke_t_
markings153410243markings
marlines103818713marlines
marlings113713493marlings
marlins93420473marlin_s
marmots11311513mar_mots
maroons92615553maroon_s
marplots1245633marplots
marranos1038423marranos
marrers93414313marre_rs
marrons93216973marron_s
marses84827113marse__s
marten84518263marten__
martinets1138883martinets
martinis103311613martinis
martins93322063martin_s
martlets103310483martlets
marts77442233mar___ts
marvels123810093marve_ls
maumets11369693maume_ts
mavens114312973ma_ven_s
mergees104411233merge_es
mergence13137943mergence
mergences14137553mergences
mergers103813423merge_rs
merges94122483merge__s
midgets113910253midge_ts
migrants1138183migrants
misagents1246793misagents
moments113113123m_oments
mordants1137143mordants
mordent10313993mordent_
moreens939963moreen_s
morgans10310123morgan_s
morgen9312203morgen__
orgeats838353_orgeats
orients7311583_orients
pageants1136693pa_geants
pangenes112612823pangenes
pangens103112063pangen_s
paraments13511553paraments
parent83230423par_ent_
parges94529543parge__s
parget94529393parge_t_
pargings123410163pargings
parvenus1335653parvenus
patents94815203pa_tents
patients1088763patients
payments1536943payments
percents122713373percents
perpents122312033perpents
portents103512823portents
raiments1039903raiments
reagents959623reagents
regents83416543_regents
rents55935183__r_ents
rerents73319423rer_ents
salients839563salients
sapients1037423sapients
sarcenets1146953sarcenets
sarges75128593sarge__s
sarment9318763sarment_
sarmenta1047723sarmenta
sarsenets946513sarsenets
sarsens7311393sarsen_s
sarsnets836783sarsnets
sergeants10115593sergeants
serpents102410373serpents
smartens10286663smarten_s
sorbents10279133sorbents
taggants1044933taggants
talents7312013ta_lents
tangent8314993tangent_
targes74524593targe__s
target75028903targe_t_
torments10310453torments
torrents838143torrents
turgent8712393turgent_
urgent73816043_urgent_
vagrants1246143vagrants
variants1139203variants
varlets10411573varle_ts
varment12313243varment_
varmints1335643varmints
wardens113711903warden_s
warrants1168503warrants
warrens103810893warren_s
wergelts1253413wergelts

Search took 9 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.1561145455.1
2DLD Change Limit1461622187.76618820.8
3Display Results2182180.0932344.1
 (SQL Overall)1786912188.01522294.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.