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

75 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
tressour844571tressour
tressours943891tressours
pressors103212692pressors
stressors955792stressors
treasons848682treasons
tressels8367652tressels
tresses73719542tress_es
arenous7314183are_nous
arsenous847533arsenous
creosols1045723creosols
cresols939653cre_sols
cresses94219813cress_es
cressets10309103cressets
dressers9359863dressers
dresses83716173dress_es
frescoes1357833frescoes
frescos1236813fresco_s
frissons1145043frissons
gessoes838293_gessoes
griseous945613griseous
lessons73811023_lessons
lessors73610523_lessors
plessors10278253plessors
precious12310593precious
preshows16267023preshows
pressers103215023pressers
presses93523153press_es
pressor93512883presso_r
pressrun1045033pressrun
pressruns1144293pressruns
prestos93716083presto_s
previous1337823previous
reasons72514943_reasons
reseaus74012153_reseaus
reshoes102316033_reshoes
reshows132510453_reshows
resinous838503_resinous
resods74116303_re_sods
resows93915353_re_sows
respots92912763_respots
strenuous944863strenuous
stresses81112493stress_es
stressful1252663stressful
stressor875543stresso_r
tedious838443t_edious
telsons739223t_elsons
tensors72712373t_ensors
tenuous738483t_enuous
testons7313563t_estons
toeshoes1147713toeshoes
transoms1048933transoms
trappous1246023trappous
trasses74819323trass_es
treason748763treaso_n
treasonous1052693treasonous
treehouse1245033treehouse
treetops1045463treetops
tremorous1145443tremorous
tremors93711233tre_mors
tremulous1144373tremulous
trespass1043383trespass
tress55423163tre_s__s
tressed83714263tress_ed
tressel73010893tress_el
tressier847963tressier
tressiest937883tressiest
tressure846483tressure
tressures946293tressures
tressy9448553tress__y
trestles83012553trestles
trismus935563tr_ismus
trussers8348283trussers
trusses73813643truss_es
trustors8268913trustors
tussors7388773t_ussors

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 Filter1786911461620.403443402.0
2DLD Change Limit146162757.81318707.5
3Display Results75750.0332272.7
 (SQL Overall)178691758.24921662.1
 
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.