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

59 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
decentest124908(None) 
recentest11410281recentest
decenter112412162decente_r
decenters122410372decenters
decentres12238522decentres_
decongest1345632decongest
detentes92712872detentes_
detentist1049322detentist
indecentest1454732indecentest
ancientest1255373ancientest
contest93523233__contest
decanes103118913decan_es_
decanted122310493decante_d
decanter112510793decante_r
decanters12229223decanters
decants103514443decant_s_
deceases11410153deceases_
decedent12310213dece_dent
deceits102810883deceit_s_
deceives1437903deceives_
decencies1448943decencies_
decent94023703decen___t
decentered1445323decentered
decently1448013decent_ly
decentre11248553decent_re
decentred13236233decentred
decongests1443243decongests
deediest102912253de_ediest
deepest10310443de_e_pest
defeatist1356603defeatist
defences1439633defences_
defenses1237913defenses_
deftest112611713d__eftest
deletes83117933dele_tes_
demented12311273demente_d
dements103016623dement_s_
densest83112473d__ensest
dentist8316743d__entist
dependent1349113dependent
descendent1446283descendent
descents112511203descent_s_
detente83313603detente__
detentists1145503detentists
detents83615153detent_s_
detest74122843d__e_test
devoutest1343643devoutest
directest1246303directest
docents102810803docent_s_
duecentos1243153duecentos_
evenest10312103_even_est
keenest11410963ke_en_est
recenter102715443recente_r
recentness1245463recentness
scantest101710183_scantest
secretest1147033secretest
serenest82717623seren_est
silentest948103silentest
teeniest82112413te_eniest
weeniest112411213we_eniest

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.423422437.4
2DLD Change Limit148641597.04621095.8
3Display Results59590.0301966.7
 (SQL Overall)178691597.49923828.6
 
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.