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

82 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
sashayed154355(None) 
ashamed1336242_ashamed
assayed1135592_assayed
sashay1238362sashay__
sashays1336332sashay_s
sashed105622942sash__ed
allayed11138063_allayed
arrayed11117153_arrayed
ascared10399523_ascared
ashed97829773_ash__ed
ashlared1253933_ashlared
assayer1035573_assayer
assuaged1044383assuaged
asswaged1343333asswaged
bashed126225703bash__ed
beshamed1635733beshamed
cascaded14135703cascaded
caseated11310713caseated
cashed125124353cash__ed
dashed115920563dash__ed
dismayed1535743dismayed
essayed1134013_essayed
fashed136720253fash__ed
gashed116321973gash__ed
hashed136021943hash__ed
hayed125822013___hayed
kashered1636403kashered
lashed105625213lash__ed
marshaled1544643marshaled
mashed125325043mash__ed
massaged1236753massaged
misassayed1652403misassayed
parlayed1435823parlayed
pashed125923143pash__ed
passaged1236243passaged
pshawed16103033_pshawed
reshaped1437203reshaped
reshaved1536873reshaved
sacheted14127833sacheted
saggared11326063saggared
salaamed1134623salaamed
salvaged1335363salvaged
sambaed1238303samba_ed
samoyed1335893sa_moyed
sandaled1039243sandaled
sapheaded1644183sapheaded
sashaying1644593sashaying
sashes94728483sash__es
sassed76116173sas__sed
satiated9311603satiated
saunaed836703sauna_ed
savaged1236993sa_vaged
sayed96127143__s_ayed
shaded114518873__shaded
shaled105023953__shaled
shamed125120213__shamed
shaped125020103__shaped
shared105829063__shared
shaved135118383__shaved
shawed134817233__shawed
slashed114114853slash__ed
slayed104716223__slayed
smashed133711223smash__ed
spayed124213613__spayed
splayed13357813s_played
sprayed13398903s_prayed
stashed113812493stash__ed
stayed104817273__stayed
strayed114513283s_trayed
subwayed1753723subwayed
swashed144311363swash__ed
swayed133510263__swayed
unashamed1543543unashamed
unassayed1343493unassayed
unshaded13149263unshaded
unshamed14148053unshamed
unshaped14148443unshaped
unshared121510703unshared
unshaved15157733unshaved
unstayed12168393unstayed
unswayed15155713unswayed
washed135521503wash__ed

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.420425454.8
2DLD Change Limit146162826.67321903.5
3Display Results82820.0332484.8
 (SQL Overall)178691827.12625075.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.