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

92 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
oddment114592(None) 
oddments1244101oddments
bodement13410122bodement
dement93825152_dement
lodgment1245982lodgment
oddest81710862odd_est
adamant101110443adamant
addend9458453add_end
addrest958633addrest
adducent1284713adducent
admen84516183_admen_
advent102613753_advent
aidmen92610373aidmen_
ailment9314233ailment
aliment9316703aliment
ament76036543__ament
ardent73022613ard_ent
audient8312303audient
augment10910203augment
badmen114613833badmen_
bodements1447613bodements
bondmen1237893bondmen_
cadent94120363cad_ent
cement103321673_cement
clement11313773clement
comment1310317703comment
condiment14410853condiment
decent94023703_decent
dements103016623_dements
dent57158413__d_ent
detent73624483_detent
docent92918683_docent
document1348663document
dolmen93911373dolmen_
dolmens10388693dolmens
dormant102814373dormant
dormient1148453dormient
element9317803element
ferment12315573ferment
figment1379743figment
fitment12710303fitment
foment113718303_foment
garment10315233garment
goodmen1135623goodmen_
hodden113811453hodd_en_
hoddens12378803hodd_ens
hutment1239173hutment
indent73021243ind_ent
judgment1944033judgment
lament85024943_lament
lodgement1345303lodgement
lodgments1344183lodgments
loment84021473_loment
madmen113511743madmen_
moment103319683_moment
monument1289903monument
mordent10313993mord_ent
movement1549433movement
obedient1176463obedient
odder74515393odd_e_r
oddness935313oddness
odorant8411393odorant
oilmen848313oilmen_
ointment1069233ointment
olden65114853old_en_
oldest72114093old_est
omen66828183o__men_
omens75618963o__mens
omenta83411723o__menta
opulent938833opulent
orient6322533o_rient
ornament1049133ornament
orpiment1247973orpiment
outwent10311363outwent
payment14310703payment
pediment13411393pediment
pigment12510733pigment
raiment9315413raiment
rident7520193rid_ent
rodent7519243rod_ent
rodmen939713rodmen_
rodsmen1035833rodsmen_
rudiment1147663rudiment
sarment9318763sarment
sediment11411103sediment
segment10312563segment
sodden84011513sodd_en_
soddens9348413sodd_ens
torment9316173torment
varment12313243varment
weldment1445823weldment
woodmen1356053woodmen_

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 Limit134027925.70323501.1
3Display Results92920.0303066.7
 (SQL Overall)178691926.13929107.5
 
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.