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

63 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
oddments124410(None) 
oddment1145921oddment_
bodements1447612bodements
dements103016622_dements
lodgments1344182lodgments
adamants1186343adamants
addends10356053add_ends
advents11309473_advents
ailments1039433ailments
aliments10311093aliments
aments85219803__aments
audients946353audients
augments1137833augments
bodement13410123bodement_
cements112714223_cements
comments142913883comments
condiments1548193condiments
dement93825153_dement_
dents65031803__d_ents
detents83615153_detents
docents102810803_docents
documents1446523documents
dolmens10388693dolmen_s
elements10312173elements
ferments13311473ferments
figments1446943figments
fitments1376793fitments
foments122912053_foments
garments1139973garments
hoddens12378803hodd_en_s
hutments1345603hutments
indents83114663ind_ents
judgments2043253judgments
laments94314853_laments
lodgements1444023lodgements
lodgment1245983lodgment_
loments93413473_loments
moments113113123_moments
monuments1397633monuments
mordents1138813mord_ents
movements1647513movements
oddest81710863odd_est_
oddness935313oddne_ss
odorants946043odorants
ointments1166653ointments
omens75618963o__men_s
omenta83411723o__menta
orients7311583o_rients
ornaments1146633ornaments
orpiments1346003orpiments
payments1536943payments
pediments1448343pediments
pigments1337343pigments
raiments1039903raiments
rodents8611543rod_ents
rudiments1245823rudiments
sarments10311963sarments
sediments1248213sediments
segments1138903segments
soddens9348413sodd_en_s
torments10310453torments
varments1339063varments
weldments1544423weldments

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 Filter1786911461620.420425454.8
2DLD Change Limit146162636.26623326.2
3Display Results63630.0331909.1
 (SQL Overall)178691636.71926594.9
 
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.