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

47 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
deterrent1012894(None) 
detergent11129571detergent
determent121312901determent
deterrents11126471deterrents
decurrent1256452decurrent
deferent122712872defe_rent
deferment151210302deferment
detergents12116662detergents
determents131010312determents
deterred10137802deterre_d
deterrence1345622deterrence
deterrently1553692deterrently
deterrer9137012deterre_r
deterrers10116592deterrers
deterring1138622deterring
betterment1446333betterment
debarment1447793debarment
decedent12310213dece_dent
decrement14411053decrement
deferents13269393defe_rents
deferments16128583deferments
deferred13106363deferre_d
deferrer12135593deferre_r
deferrers13115153deferrers
deferring1436143deferring
dependent1349113dependent
detent73624483det___ent
deterge9118463deterge__
deterged11127923deterge_d
detergency1754183detergency
deterger10147593deterge_r
detergers11147183detergers
deterges101510093deterge_s
deterging1237853deterging
determine1249033determine
deterrences1455183deterrences
detriment1249693detriment
divergent1447363divergent
emergent1149113_emergent
interlent9416733interlent
interment11419223interment
recurrent1146713recurrent
referent112813423refe_rent
reverent112615093reve_rent
terrene72411033__terrene
terret63425623__terre_t
torrent7313413__torrent

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 Filter1786911486410.453394461.4
2DLD Change Limit148641477.70319296.5
3Display Results47470.0162937.5
 (SQL Overall)178691478.17221866.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.