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

206 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
essayed113401(None) 
assayed1135591assayed
essayer1033941essayer
assayer1035572assayer
embayed1535442embayed
enskyed1532502enskyed
escaped12388852escaped
essay867622essay__
essayers1133562essayers
essays965652essay_s
estated83715572estated
estrayed1236392estrayed
messaged1235542messaged
sayed96127142__sayed
slayed104716222_slayed
spayed124213612_spayed
stayed104817272_stayed
swayed133510262_swayed
unessayed1342942unessayed
allayed11138063allayed
ansated84214003ansated
arrayed11117153arrayed
ascared10399523ascared
ashamed1336243ashamed
assailed945323assailed
assay8710283assay__
assayers1144843assayers
assays977903assay_s
assuaged1044383assuaged
assumed1065293assumed
assured858373assured
asswaged1343333asswaged
bayed115423023__bayed
belayed133610083belayed
bendayed1534873bendayed
beshamed1635733beshamed
beslaved1435023beslaved
betrayed1436303betrayed
bewrayed1733933bewrayed
brayed124615783_brayed
cessed94615613cess__ed
clayed125013043_clayed
decayed14309333decayed
deejayed2042443deejayed
defrayed1635403defrayed
delayed123310763delayed
dismayed1535743dismayed
dissaved1337313dissaved
drayed115911393_drayed
eared65139503e__ared
eased65430403e__ased
easeled8159853easeled
eaved95924503e__aved
effaced16225573effaced
elated74725823e_lated
empaled12288953empaled
encaged113211083encaged
encased103512313encased
enfaced13218913enfaced
engaged10379833engaged
enjoyed1834523enjoyed
enlaced102410523enlaced
enraged93511783enraged
ensiled82611433ensiled
enskied1234653enskied
enslaved1245063enslaved
ensnared965293ensnared
ensued73610483ens_ued
ensured83512943ensured
epoxyed2032293epoxyed
equaled17166923equaled
equated171910403equated
erased74816753e_rased
escape103811663escape_
escapee113310463escapee
escaper11368843escaper
escapes113811673escapes
escarped1355163escarped
escoted1038183escoted
espied9359773e_spied
essaying1235033essaying
essayist1143623essayist
esses56422973ess__es
estate64719763estate_
estates74520183estates
evaded1137063e_vaded
exhaled1835283exhaled
eyed86623233e___yed
fayed126422153__fayed
fessed104515063fess__ed
flayed134414053_flayed
forayed14368593forayed
frayed135012163_frayed
gessoed935743gess_oed
gestated102910573gestated
grayed115415643_grayed
hayed125822013__hayed
hoseyed1436953hoseyed
issued746723iss_ued
jerseyed1942733jerseyed
jessed144112303jess__ed
layed95127383__layed
lessened935093lessened
lessoned945393lessoned
massaged1236753massaged
mayed115522403__mayed
message1037833message_
messages1138233messages
messed95018183mess__ed
moseyed1336133moseyed
okayed1434253_okayed
passaged1236243passaged
payed115925933__payed
played124815033_played
prayed124815433_prayed
pshawed16103033pshawed
rayed95127503__rayed
relayed113212753relayed
replayed14248623replayed
resawed113111183resawed
rescaled113311303rescaled
resealed92713963resealed
reseated93220263reseated
reshaped1437203reshaped
reshaved1536873reshaved
reslated93517523reslated
resoaked1337943resoaked
respaced1338503respaced
respaded1238133respaded
resprayed1544353resprayed
restaged103011863restaged
restated93120183restated
sabed86526813__sabed
saned65636273__saned
sashayed1543553sashayed
sashed105622943_sashed
sassed76116173_sassed
sated66238533__sated
saved95127113__saved
sawed95628403__sawed
sayeds10469253__sayeds
sayer84926553__sayer
sayid95516723__sayid
scaled94822443_scaled
scaped115519553_scaped
scared95227293_scared
seabed95017693_seabed
sealed74328363_sealed
seamed94823883_seamed
seared75232843_seared
seated75131053_seated
sedated93714343sedated
seesawed1243293seesawed
sensated938183sensated
sepaled10510593sepaled
sesame8311013sesame_
sesames9310743sesames
shaded114518873_shaded
shaled105023953_shaled
shamed125120213_shamed
shaped125020103_shaped
shared105829063_shared
shaved135118383_shaved
shawed134817233_shawed
skated114414883_skated
skyed13529923__skyed
slaked114318273_slaked
slated75028313_slated
slaved104017043_slaved
slayer93916333_slayer
snaked115017593_snaked
snared74824553_snared
snawed104813733_snawed
soaked114717593_soaked
soaped95817973_soaped
soared74324293_soared
spaced114517253_spaced
spaded103816753_spaded
spaed85522273_spa_ed
spared95427493_spared
splayed13357813splayed
sprayed13398903sprayed
staged84521563_staged
staked114621943_staked
staled74728103_staled
staned74824643_staned
stared75429873_stared
stated75427833_stated
staved103918053_staved
stayer94516483_stayer
strayed114513283strayed
styed95815483__styed
swaged114212253_swaged
swayer125210973_swayer
unassayed1343493unassayed
unsated83419933unsated
unsaved113312193unsaved
unsawed112911503unsawed
unstayed12168393unstayed
unswayed15155713unswayed
vesseled1243803vesseled
visaed104110503visa_ed
visaged1235683visaged
wessand1144833wessa_nd
yeasayer1442353yeasayer
yessed104511163yess__ed

Search took 7 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 Filter1786911340270.1561145455.1
2DLD Change Limit1340272066.58020368.8
3Display Results2062060.0762710.5
 (SQL Overall)1786912066.81226231.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.