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

203 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
reagents95962(None) 
reagent8716601reagent_
regents83416541re_gents
agents74816292__agents
coagents1138452coagents
reaccents1365852reaccents
reagins84215642reagin_s
reascents1177402reascents
regent74127672re_gent_
relents74018502re_lents
repents93717622re_pents
rerents73319422re_rents
resents74221222re_sents
agenes74720253__agenes
agent65829643__agent_
aments85219803__aments
argents84014853_argents
armaments1347473armaments
begets96215523be_ge_ts
beignets11155373beignets
cements112714223ce_ments
coagent10313983coagent_
crescents1367543crescents
deadens93410693deaden_s
deafens11317253deafen_s
decadents1346393decadents
dements103016623de_ments
descents112511203descents
detents83615153de_tents
dragnets10136563dragnets
eagers74523683_eage_rs
eaglets84111663_eaglets
egests74411253_e_gests
eluents738703_eluents
emergents1245973emergents
events94814073_e_vents
extents142610173_extents
ferments13311473ferments
fragments1546213fragments
frequents2144443frequents
gents65729613___gents
gerents82612923ge_rents
greatens9307593greaten_s
headends13326723headends
heavens13439303heaven_s
lagends947273_lagends
laments94314853_laments
latents75214313_latents
leadens83610983leaden_s
leavens10409303leaven_s
legends936073le_gends
magenta1038623_magenta
magentas1137923_magentas
magnets10311143_magnets
margents11410133margents
misagents1246793misagents
neatens73310403neaten_s
newsagents1452223newsagents
ornaments1146633ornaments
pageants1136693_pageants
parents93418123_parents
patents94815203_patents
peages94321843peage__s
peahens12307573peahen_s
peasants1038263peasants
pendents1139413pendents
percents122713373percents
perpents122312033perpents
precents123015043pre_cents
presents103315643pre_sents
prevalents1594973prevalents
prevents133012293pre_vents
ragees74618663r_age_es
rages64539443r_age__s
ragouts838543r_agouts
raiments1039903raiments
ramenta9311183r_amenta
ramets83517393r_ame_ts
rants55935343r_a__nts
ravens93916883r_aven_s
reaccent1278573reaccent_
reaccepts1583213reaccepts
reactants1146623reactants
reacts83616603rea__cts
readapts1145583readapts
readers83823773reade_rs
readings103512643readings
readmits1136653readmits
readopts1146493readopts
readouts938903readouts
reagin74915533reagin__
reaginic1144453reaginic
reales64934123reale__s
realest73322433realest_
realists83014843realists
reallots837993reallots
realness8410443realness
reamers94221083reame_rs
reanoints945363reanoints
reapers93520453reape_rs
rearers74323563reare_rs
rearguments1483843rearguments
rearrests945313rearrests
reascends1244293reascends
reascent10411983reascent_
reasons72514943reason_s
reasserts945983reasserts
reavers108320743reave_rs
reaves94127573reave__s
reblends1135293reblends
reblent9614253reblent_
recants93217093re_cants
recements13312283recements
recent83630853re_cent_
recepts113010263re_cepts
recheats1339193recheats
recounts1038773recounts
recreants1146623recreants
reddens9259783redden_s
redigests1154683redigests
reejects17336083reejects
reelects103110883reelects
reerects10319923reerects
reests64618893re__ests
refects124012743re_fects
referents12259643referents
reflects13288873reflects
reflets103513153refle_ts
refronts1137773refronts
regains84316583regain_s
regears83012463re_gears
regency1337363re_gency
regental948943re_gental
reges65628783re_ge__s
regiments123910323regiments
reginas85614063re_ginas
reglets83512983re_glets
regrants9310013regrants
regreets9287853regreets
regrets83212923re_grets
reheats104513523re_heats
reigns74811753reig_n_s
reinvents1246123reinvents
rejects163910693re_jects
relaxants1643243relaxants
relends84013253re_lends
relent64431853re_lent_
relets64025673re_le_ts
rellenos8125493rellenos
remanent10311703remanent_
remeets93712413re_meets
remelts93511493re_melts
remends105013033re_mends
remints95117293re_mints
remnants1036843remnants
remounts1036373remounts
renests74014213re_nests
rennets75212633renne_ts
rents55935183r___ents
reopens939373reopen_s
reorients997363reorients
repaints1038483repaints
repayments1744903repayments
repeats94316053re_peats
repent84728873re_pent_
repigments1546343repigments
replants102811243replants
reprints1039903reprints
requests1735743requests
rerent63832453re_rent_
reseats74319583re_seats
resects94115593re_sects
resends83513713re_sends
resent63833623re_sent_
resets65427613re_se_ts
residents1038423residents
resmelts1046143resmelts
respects1247703respects
retargets1045303retarge_ts
retenes76324623re_tenes
retests73813853re_tests
retints74717013re_tints
retreats8311413retreats
reverts104715043re_verts
revests104413733re_vests
revets94022173re_ve_ts
rewakens15406243rewaken_s
rewets94617213re_we_ts
ringent8315153ringent_
rodents8611543r_odents
sealants82610743sealants
seawants11337973seawants
segments1138903segments
sequents1756993sequents
sergeants10115593sergeants
serpents102410373serpents
subagents1245003subagents
talents7312013_talents
tangents938713tangents
treatments1246283treatments
weakens14367063weaken_s
wergelts1253413wergelts
yearends12234483yearends

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.1601116818.8
2DLD Change Limit1461622036.93621073.0
3Display Results2032030.0762671.1
 (SQL Overall)1786912037.17224915.1
 
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.