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

91 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
ashlared125393(None) 
ashlered1244621ashlered
ascared10399522as_cared
ashamed1336242ash_amed
ashlar9338192ashlar__
ashlars10297062ashlar_s
shared105829062_sh_ared
sheared114516002_sheared
abhorred1443493abhorred
ablated102513443a_blated
acylated1437873acylated
adhered1239233adh_ered
adulated1039753adulated
afeared1176833a_feared
aglare7312423a_glare_
alarmed1037733a__larmed
alated75625143a__lated
allayed11138063a_llayed
allured8299173a_llured
aneared8512743a_neared
antlered938253antlered
appeared1336143appeared
ascarid103910723as_carid
ashcake1663373ashcake_
ashcakes1753733ashcakes
ashed97829773ash___ed
ashlaring1344493ashlaring
ashler9459973ashl__er
ashlers10319583ashler_s
ashore9414613ash_ore_
asphalted1543113asphalted
aspired1068173as_pired
assayed1135593as_sayed
assuaged1044383assuaged
assured858373as_sured
asswaged1343333asswaged
blared95018243__blared
cashiered1543403cashiered
cellared11398793cellared
chared125423693_ch_ared
collared113211143collared
declared1248743declared
flared105317603__flared
glared84715193__glared
hared95742183__h_ared
isolated9410523isolated
kashered1636403kash_ered
pillared11228093pillared
pshawed16103033psh_awed
saggared11326063saggared
salaried9311023_salaried
sashayed1543553sash_ayed
scared95227293_s_cared
seared75232843_s_eared
shaded114518873_sh_aded
shaled105023953_sh_aled
shamed125120213_sh_amed
shaped125020103_sh_aped
shard96125963_sh_ar_d
share86437083_sh_are_
sharer95025483_sh_arer
shares95236413_sh_ares
sharked153613913_sh_arked
sharped134112053_sh_arped
shaved135118383_sh_aved
shawed134817233_sh_awed
sheafed14388973_sheafed
shearer104414683_shearer
sheaved143411633_sheaved
sheered113515453_sheered
shirred113710503_shirred
shoaled113810973_shoaled
shored105723653_sh_ored
shred98125613_sh__red
slaked114318273_s_laked
slated75028313_s_lated
slaved104017043_s_laved
slayed104716223_s_layed
smeared104510623_smeared
snared74824553_s_nared
soared74324293_s_oared
solaced102911063_solaced
solated83618023_solated
spared95427493_s_pared
speared104314423_speared
splayed13357813_splayed
squared173610563_squared
stared75429873_s_tared
sugared938583_sugared
unshared121510703unsh_ared
ushered1139153ush_ered

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.1731032896.0
2DLD Change Limit146162917.43619656.0
3Display Results91910.0461978.3
 (SQL Overall)178691917.65523343.0
 
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.