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

218 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
assayed113559(None) 
assayer1035571assayer
essayed1134011essayed
allayed11138062allayed
ansated84214002ansated
arrayed11117152arrayed
ascared10399522ascared
ashamed1336242ashamed
assailed945322assailed
assay8710282assay__
assayers1144842assayers
assays977902assay_s
assuaged1044382assuaged
assumed1065292assumed
assured858372assured
asswaged1343332asswaged
essayer1033942essayer
massaged1236752massaged
passaged1236242passaged
sashayed1543552sashayed
sayed96127142__sayed
slayed104716222_slayed
spayed124213612_spayed
stayed104817272_stayed
swayed133510262_swayed
unassayed1343492unassayed
aahed917816443a__ahed
abased96514993a_based
abashed1357663abashed
abated95918453a_bated
ablated102513443ablated
abraded1138643abraded
aerated85322373aerated
afeared1176833afeared
affrayed1842843affrayed
aisled74516183ais_led
alated75625143a_lated
alcayde13103723alcayde
allayer10148213allayer
alloyed11158033alloyed
amassed10388633amassed
amazed18519313a_mazed
aneared8512743aneared
annoyed1185873annoyed
ansae55720973ansa_e_
ansate64517863ansate_
arcaded1178973arcaded
arrased8149863arrased
arrayer10136703arrayer
ascarid103910723ascarid
ashed97829773a_s_hed
ashlared1253933ashlared
asked106919313a_s_ked
aspired1068173aspired
assagai843903assagai
assagaied1142173assagaied
assai5711543assa__i
assail6610153assa_il
assailer844823assailer
assails769093assails
assais6711963assa_is
assault747413assault
assaulted1042583assaulted
assaying1236003assaying
assegaied1142503assegaied
assented957513assented
asserted957903asserted
asses55629283ass__es
assessed945023assessed
asset55932263ass__et
assigned1044633assigned
assisted936233assisted
assize1538633assize_
assizes1638453assizes
assoiled935023assoiled
assorted956603assorted
assuage835683assuage_
assuager944343assuager
assuages936273assuages
assume897563assume_
assumer965363assumer
assumes967163assumes
assure6610773assure_
assureds984493assureds
assurer767793assurer
assures7611403assures
asswage1144673asswage_
asswages1255053asswages
aurated83817793aurated
aviated11310263aviated
awaked14579203a_waked
axseed1456993axs_eed
balsamed1344543balsamed
basseted1136743basseted
bayed115423023__bayed
belayed133610083belayed
bioassayed1651153bioassayed
brayed124615783_brayed
cascaded14135703cascaded
caseated11310713caseated
clayed125013043_clayed
decayed14309333decayed
delayed123310763delayed
dismayed1535743dismayed
dissaved1337313dissaved
drayed115911393_drayed
embayed1535443embayed
enskyed1532503enskyed
escaped12388853escaped
essay867623essay__
essayers1133563essayers
essays965653essay_s
estated83715573estated
estrayed1236393estrayed
fayed126422153__fayed
flayed134414053_flayed
forayed14368593forayed
frayed135012163_frayed
gassed85217633gass__ed
grayed115415643_grayed
hassled11358303hass_led
hayed125822013__hayed
hoseyed1436953hoseyed
issued746723iss_ued
lassoed8408743lass_oed
layed95127383__layed
massacred1443193massacred
massage1039893massage_
massager1136873massager
massages1159883massages
massed94421323mass__ed
mayed115522403__mayed
messaged1235543messaged
misassayed1652403misassayed
moseyed1336133moseyed
naysayer1442583naysayer
okayed1434253_okayed
parlayed1435823parlayed
passade1039233passade_
passades1139203passades
passage1039803passage_
passages1139513passages
passed94320943pass__ed
payed115925933__payed
played124815033_played
prayed124815433_prayed
pshawed16103033pshawed
rassled83310453rass_led
rayed95127503__rayed
relayed113212753relayed
resawed113111183resawed
sabed86526813__sabed
samoyed1335893samoyed
saned65636273__saned
sashed105622943sas_hed
sassed76116173sas_sed
sated66238533__sated
savaged1236993savaged
saved95127113__saved
sawed95628403__sawed
sayeds10469253__sayeds
sayer84926553__sayer
sayid95516723__sayid
scaled94822443_scaled
scaped115519553_scaped
scared95227293_scared
seabed95017693_seabed
sealed74328363_sealed
seamed94823883_seamed
seared75232843_seared
seated75131063_seated
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
tasseled935593tasseled
unessayed1342943unessayed
unsated83419933unsated
unsaved113312193unsaved
unsawed112911503unsawed
unstayed12168393unstayed
unswayed15155713unswayed
visaed104110503visa_ed
visaged1235683visaged
wassailed1343153wassailed

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.406440125.6
2DLD Change Limit1340272186.20321606.8
3Display Results2182180.0802725.0
 (SQL Overall)1786912186.68926714.2
 
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.