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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

142 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
egressed104687(None) 
egresses949441egresses
regressed1138111regressed
aggressed1244202aggressed
caressed1139162caressed
degreased1244712degreased
depressed1357622depressed
digressed1245612digressed
dressed93511872_dressed
egested938122eg_ested
egress73310432egress__
engrossed1144312engrossed
excessed1844942excessed
expressed1946212expressed
grassed93812792_grassed
greased93812392_greased
grossed93812252_grossed
guessed9176602_guessed
ogresses938472ogresses
pressed103317312_pressed
redressed1137772redressed
regresses10310462regresses
repressed12610102repressed
stressed9128542stressed
tressed83714262_tressed
accessed1385403accessed
addressed1243653addressed
aggresses1146143aggresses
agreed84712503agre__ed
appressed1445943appressed
arrested939153arrested
assessed945023assessed
blessed10319493_blessed
brassed103612373_brassed
caresser1038813caresser
caresses10314063caresses
cessed94615613__cessed
congressed1445463congressed
creased104315583_creased
cresses94219813_cresses
cresset93319943_cresset
crested103416533_crested
crossed105313893_crossed
decreased1345453decreased
degassed11275963deg_assed
degaussed1242543degaussed
degrease1045413degrease_
degreaser1144333degreaser
degreases1146153degreases
degreed10258883degre__ed
depresses1259883depresses
digresses1137863digresses
dresser83611953_dresser
dresses83716173_dresses
duresses939173duresses
egressing1146853egressing
egression1046193egression
egrets72712243egrets__
eldresses1045673eldresses
embossed1344693embossed
emersed10138513e_mersed
empresses1348163empresses
engrosser1043843engrosser
engrosses1045473engrosses
enmeshed1444163enmeshed
erased74816753e_r_ased
erected103213993e_rected
excesses1736753excesses
expensed18126413expensed
expresser1845733expresser
expresses1837863expresses
fessed104515063__fessed
finessed12136793finessed
forested12312463forested
freshed143312593_freshed
gassed85217633_g_assed
gessoed935743_g_essoed
glassed93710433_glassed
glossed94410073_glossed
grasped11409063_grasped
grasses84117343_grasses
grease75416233_grease_
greaser83913083_greaser
greases84816713_greases
greaved12408913_greaved
greed75125693_gre__ed
greened93111263_greened
greeted93111383_greeted
greisen856503_greisen
greyed114610603_gre_yed
grosser84313143_grosser
grosses84517683_grosses
groused94712833_groused
guesser8166543_guesser
guesses8169373_guesses
guested9157713_guested
harassed1237113harassed
harnessed13186193harnessed
heiresses1236963heiresses
impressed1446283impressed
ingresses1038533ingresses
jessed144112303__jessed
messed95018183__messed
obsessed1144273obsessed
ogress7529503ogress__
oppressed1445123oppressed
peeresses1138473peeresses
presser93717623_presser
presses93523153_presses
prissed103311263_prissed
progressed1445353progressed
recessed1139713recessed
recrossed1246513recrossed
redigressed1453013redigressed
redresser1056793redresser
redresses10410293redresses
refreshed1685613refreshed
reglossed1144003reglossed
regreened1145553regreened
regreeted1136173regreeted
regress82711453regress__
regressor1064613regressor
regretted1137233regretted
represser1168953represser
represses11412143represses
reseed74823293__reseed
rested74430783__rested
restressed1146653restressed
reused75419563__reused
seeresses939053seeresses
stresses81112493stresses
threshed1535643threshed
tigresses1046403tigresses
tressel73010893_tressel
tresses73719543_tresses
trussed84010033_trussed
undressed1138343undressed
ungreased1136333ungreased
unpressed1237953unpressed
unrested91914513unrested
wrested113410933_wrested
yessed104511163__yessed

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.423422437.4
2DLD Change Limit1461621427.53319402.9
3Display Results1421420.0463087.0
 (SQL Overall)1786911428.00222330.8
 
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.