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

67 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
stressor87554(None) 
stressors955791stressors
pressor93512882_pressor
stress66616672stress__
stressed9128542stressed
stresses81112492stresses
tressour844572_tressour
addressor1142503addressor
aggressor1142553aggressor
arrestor847653arrestor
assessor843623assessor
attestor845463attestor
caresser1038813caresser
colessor1045233colessor
depressor1265173depressor
dresser83611953_dresser
espresso1043193espresso_
espressos1143973espressos
lessor64010603__lessor
obsessor1043033obsessor
oppressor1363813oppressor
plessor9317693_plessor
presser93717623_presser
pressors103212693_pressors
redressor1064223redressor
regressor1064613regressor
repressor1166343repressor
scissor994123s_cissor
seisor63712343s__eisor
sensor63813843s__ensor
stemson945163st_emson
stentor739383st_entor
stepson945673st_epson
sternson844843sternson
stertor7310093st_ertor
stetson745783st_etson
strass67117223strass__
strasses81311443strasses
streaker12229483streaker
streamer10239513streamer
streeker12206643streeker
streps86218063streps__
stressful1252663stressful
stressing1038333stressing
stretto737733stretto_
strettos847113strettos
streusel843933streusel
strewer104310413stre_wer
strews96817103strews__
stridor8467393str_idor
sublessor1143653sublessor
successor1343063successor
suppressor14113253suppressor
tensor63812673_t_ensor
treason748763_treason
tremor84210403_tre_mor
tress55423163_tress__
tressed83714263_tressed
tressel73010893_tressel
tresses73719543_tresses
tressier847963_tressier
tressours943893_tressours
tressure846483_tressure
tressy9448553_tress_y
trusser74010263_trusser
trustor7238413_trustor
tussor6378233_t_ussor

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 Filter1786911461620.423422437.4
2DLD Change Limit146162677.35619869.8
3Display Results67670.0332030.3
 (SQL Overall)178691677.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.