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

89 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
ashlered124462(None) 
ashlared1253931ashlared
adhered1239232adh_ered
antlered938262antlered
ashler9459972ashler__
ashlers10319582ashler_s
cashiered1543402cashiered
kashered1636402kash_ered
sheered113515452_sheered
ushered1139152ush_ered
abhorred1443503abhorred
achieved1743713achieved
adhere10310333adh_ere_
adherend1343863adh_erend
adherer1137573adh_erer
adheres11310163adh_eres
alerted82512223a__lerted
alleged9389323a_lleged
allured8299173a_llured
altered83215743a_ltered
angered93013473a_ngered
answered1235493answered
ascared10399523as_cared
ashamed1336243ash_amed
ashed97829773ash___ed
ashier94714833ashier__
ashlar9338193ashlar__
ashlars10297063ashlar_s
ashlering1344153ashlering
ashless10318453ashle_ss
ashore9414613ash_ore_
asleep847283as_le_ep
aspersed11428293as_persed
aspired1068173as_pired
asserted957903as_serted
assured858373as_sured
athlete1068083athlete_
athletes1157883athletes
cashmere1564323cashmere_
cashmeres1654393cashmeres
cheered133713293_cheered
cohered133514693coh_ered
coshered14610293cosh_ered
fathered151510433fath_ered
fullered1236383fullered
gathered13149383gath_ered
hollered1237603hollered
inhered11313163inh_ered
isleted837523is_leted
koshered1636063kosh_ered
lathered121512333lath_ered
mastered112614003mas_tered
ochered132610283och_ered
osiered837123os_iered
sabered103213023_sabered
saggered11237553saggered
sclereid1145363_sclereid
sered65737293_s__ered
severed113513863_severed
sewered112911243_sewered
shared105829063_sh_ared
sheared114516003_sheared
sheened113511703_sheened
sheerer103813843_sheerer
sheeted113813043_sheeted
shelled113815093_shelled
sheltered1335573_sheltered
shelved14379933_shelved
sherd96321153_sh_er_d
shewed134716183_sh_ewed
shirred113710503_shirred
shivered15177103_shivered
shlepped1633643_shlepped
shored105723653_sh_ored
showered1537013_showered
shred98125613_sh__red
shrewed14589853_shrewed
silvered12237563_silvered
slewed104815523_s_lewed
sneered83113973_sneered
sobered102912433_sobered
soldered1038153_soldered
soleret7321233_soleret
speered103614813_speered
sphered133512313_sphered
spiered104412463_spiered
steered83615253_steered
supered10316123_supered
tillered937443tillered

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 Filter1786911461620.420425454.8
2DLD Change Limit146162896.43622710.1
3Display Results89890.0332697.0
 (SQL Overall)178691896.88925938.6
 
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.