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

58 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
document134866(None) 
documents1446521documents
decumbent1644702decumbent
docent92918682doc__ent
documental1554512documental
documented1653202documented
documenter1553282documenter
monument1289902monument
accumbent1743453accumbent
acumen1049013_acumen_
acumens1136953_acumens
adornment1246273adornment
argument1158903argument
bodement13410123bodement
cement103321663__cement
comment1310317703co_mment
decadent1249003decadent
decedent12310213decedent
decent94023703dec__ent
decrement14411053decrement
decuman1236573decuman_
decurrent1256453decurrent
dement93825143d__ement
diluent8310263dilu_ent
diriment11410743diriment
docents102810803doc__ents
docket134721173doc_ke_t
documentary1953063documentary
documenters1652813documenters
documenting1753123documenting
dolmen93911373do_lmen_
dolmens10388693do_lmens
doormen1036753doormen_
dormant102814373do_rmant
dormient1148453dormient
dourest8312943do_urest
emolument1346733emolument
esculent1047183esculent
feculent1346953feculent
foment113718303fo__ment
incumbent1545633incumbent
lodgment1245983lodgment
loment84021473lo__ment
luculent1045803luculent
moment103319683mo__ment
monuments1397633monuments
movement1549433movement
nocent83217413noc__ent
noumena945633no_umena
oddment1145923_oddment
opulent938833_opulent
procumbent1852923procumbent
recement12315653recement
recumbent1545323recumbent
sockmen1535453sockmen_
socmen1039193soc_men_
tegument1177523tegument
torment9316173to_rment

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 Limit146162588.48317230.0
3Display Results58580.0461260.9
 (SQL Overall)178691588.68520574.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.