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

90 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
decimating164875(None) 
decimation15411622decimation
decimations16410162decimations
decorating14312072decorating
dedicating1539142dedicating
delimiting1445842delimiting
depilating1439182depilating
deviating14311082devi_ating
acclimating1845283acclimating
animating12312503_animating
checkmating2552433checkmating
deactivating1953453deactivating
deaerating12311563deaerating
deaminating1547973deaminating
debating123213733de__bating
debiting122511203debi__ting
decamping1734943decam_ping
decanting132510633dec_anting
decapitating1854953decapitating
decaying15239453dec__aying
deceasing1338403dec_easing
deciding132210833deci__ding
decimalize2446603decimalize
decimalizing2755963decimalizing
decimate13411123decimat__e
decimated1548953decimat_ed
decimates14410693decimat_es
decimator1447733decimat_or
decimators1547503decimators
declaring1339573dec_laring
declawing1636213dec_lawing
decocting1538123dec_octing
decollating1545963decollating
decreasing1446513decreasing
decrypting1943213decrypting
decussating1543193decussating
defeating142311973de_feating
defecating17237783defecating
defilading1643643defilading
deflating142610713de_flating
delating103119603de__lating
delegating1337673delegating
delighting1644993delighting
deliming12310373delim__ing
delineating1346373delineating
delisting112710503deli_sting
demasting1338453de__masting
demitting13239073demi_tting
demoting12311423de__moting
denigrating14146923denigrating
denitrating13128333denitrating
denudating1345263denudating
depicting1537813depi_cting
depurating1438643depurating
deracinating1645223deracinating
derating103222283de__rating
derogating1348633derogating
desiccating1744703desiccating
designating1446073designating
desisting112810383desi_sting
desolating1239463desolating
despumating1743693despumating
detonating1248823detonating
dictating1338883dic_tating
dilating102714903d__ilating
dominating1449403dominating
epilating12310963_epilating
estimating1348883estimating
geminating1447753geminating
gemmating1576443ge_mmating
hesitating1448003hesitating
intimating13410823intimating
levigating1545693levigating
levitating1446653levitating
mediating13311203medi_ating
medicating1648953medicating
meditating1448123meditating
peculating1549153peculating
reanimating1447233reanimating
reciting113118073reci__ting
recoating121317463rec_oating
recrating121318793rec_rating
recreating131214583recreating
reimaging1336503re_imaging
remating112322413re__mating
resinating11313733resinating
seriating10916403seri_ating
speciating1548123speci_ating
ultimating1386803ultimating
vesicating1646893vesicating

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 Filter1786911406030.423422437.4
2DLD Change Limit140603905.67324784.6
3Display Results90900.0461956.5
 (SQL Overall)178691906.14229093.3
 
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.