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

62 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
agendum114467(None) 
agendums1243441agendums
addendum1342312addendum
agenda837252agend_a
agendas936932agendas
argentum1145362argentum
acetum1038463ace_tum
addendums1451953addendums
aecium10410423a_ecium
aeneus61111143a_eneus
aged67334253age_d__
agedly1136463age_dly
ageism968803age_ism
agency1237033agen_cy
agene65621583agen__e
agenes74720253agen_es
agenize172910153agenize
agent65829643agen__t
agented939423agented
agentry11165753agentry
agents74816293agen_ts
ageratum1143463ageratum
amend85717753amend__
amended11328313amended
amender10349613amender
amends94713283amend_s
arenous7314183arenous
argentums1243873argentums
atheneum1363223atheneum
augend837633augend__
augends935883augend_s
avenue957953aven_ue
centum104012363_centum
cundum1136513_cundum
endue64215353__endue
frenum1188803fren_um
gender83517933_gender
genius74512923_genius
genom83716843_gen_om
genu55929073_gen_u_
genua64614153_gen_ua
genus65319833_gen_us
geum75424553_ge__um
gonium949803_gonium
lagend838743lagend__
lagends947273lagend_s
magnum1136733mag_n_um
mentum104511713_mentum
omentum1155933omentum
pagandom1443533pagandom
plenum1039503plen_um
pudendum1442623pudendum
ramentum1244863ramentum
regnum957163regn_um
rhenium1246243rhenium
sedum84115573_se_dum
sendup9106343_sendup
sensum849353_sensum
smeddum1342853smeddum
tendu67216003_tendu_
tendus75111183_tendus
vendue10419013_vendue

Search took 7 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 Limit134027625.95322514.2
3Display Results62620.0163875.0
 (SQL Overall)178691626.37528030.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.