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 “redact” with Change Limit: [1] [2] [3]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

46 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
redact941904(None) 
react74634331re_act
redacts10510941redacts
deduct10610792deduct
didact10711202didact
edict84722282_edict
educt85017102_educt
enact73525362_enact
epact94921532_epact
exact143516932_exact
pedant9319492pedant
preact103220392pre_act
predict12315322predict
reach105123882re_ach
reacts83616602re_acts
readapt1039742readapt
rebait8320402rebait
recant83228682recant
recast83422772recast
redacted12410242redacted
redactor1147032redactor
redan66125012reda_n
redans75421022redans
redate74124682redate
redbait1039802redbait
redcap1158492redcap
redipt94116742redipt
redock134311542redock
redout71820252redout
redraft11310572redraft
reduce9713252reduce
reenact9413012reenact
reface113616352reface
refect114319332refect
refract121311602refract
reject154116282reject
relace83122152relace
relict83623902relict
reluct83916112reluct
repack142412162repack
repast83520632repast
rerack122513162rerack
resat55139682resa_t
resect84424702resect
retack122612822retack
retract91318112retract

Search took 4 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 Filter178691825510.356501941.0
2DLD Change Limit82551462.84629006.0
3Display Results46460.000 
 (SQL Overall)178691463.20255806.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.