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

49 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
detergent1112957(None) 
detergents12116661detergents
determent121312901determent
deterrent10128941deterrent
deferent122712872defer_ent
deferment151210302deferment
deterge9118462deterge__
deterged11127922deterge_d
detergency1754182detergency
deterger10147592deterge_r
detergers11147182detergers
deterges101510092deterge_s
deterging1237852deterging
determents131010312determents
deterrents11126472deterrents
divergent1447362divergent
emergent1149112_emergent
betterment1446333betterment
debarment1447793debarment
decedent12310213dece_dent
decrement14411053decrement
decurrent1256453decurrent
deferents13269393defer_ents
deferments16128583deferments
demerge11168023demerge__
demerged13157603demerge_d
demerger12127373demerge_r
demergers13146403demergers
demerges12129503demerge_s
demerging1436643demerging
dependent1349113dependent
detent73624483det___ent
determine1249033determine
deterred10137803deterre_d
deterrence1345623deterrence
deterrently1553693deterrently
deterrer9137013deterre_r
deterrers10116593deterrers
deterring1138623deterring
detriment1249693detriment
emergents1245973_emergents
heterogeny1754333heterogeny
interlent9416733interlent
interment11419223interment
referent112813423refer_ent
resurgent1047953resurgent
retarget9312743retarge_t
reverent112615093rever_ent
turgent8712393__turgent

Search took 8 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 Filter1786911486410.406440125.6
2DLD Change Limit148641497.39320105.6
3Display Results49490.0133769.2
 (SQL Overall)178691497.81222873.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.