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

81 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
asylums124363(None) 
amylums1473611amylums
asylum1144891asylum_
alums75720602a__lums
amylum1344692amylum_
asarums9467612asarums
slums74623432_s_lums
solums85211332_solums
abysms13565653aby_sms
acyls104211523acyl__s
adytum1243733adytum_
alarums9408923alarums
albums10198273a_lbums
algums9208043a_lgums
alliums957973alliums
alms65834923a__l_ms
alum65227613a__lum_
alyssums1341963alyssums
amyls104512693amyl__s
antrums969173antrums
arums75517833a__rums
aryls87015813aryl__s
asarum84610913asarum_
ascus75013583as_cu_s
ashlars10297063ashlars
ashlers10319583ashlers
ashless10318453ashless
ashrams1236653ashrams
assume897563as_sume
assumes967163as_sumes
asyla839333asyl__a
atriums939043atriums
aurums849383a_urums
baculums1443723baculums
estrums9208603estrums
glums84621423__glums
hassiums1344273hassiums
lums65734243___lums
osmiums1134143osmiums
pablums1345123pablums
pabulums1443003pabulums
peplums13145503peplums
phylum1655153phylum_
plums94619953__plums
psalms1045673psal_ms
psyllas1244883psyllas
psylliums1642193psylliums
sacrums11388043sacrums
scrums104614253_scrums
scums95017423_s_cums
sebums10369813_sebums
sedums93910483_sedums
serums83916303_serums
shlubs11386733_shlubs
shlump1345713_shlump
shlumps1434143_shlumps
slams74927903_s_lams
slims75423653_s_lims
slubs74719533_s_lubs
slues54527173_s_lues
slugs64618563_s_lugs
slum65430513_s_lum_
slump94816633_s_lump
slumps104313583_s_lumps
slurs54123373_s_lurs
sluts54523983_s_luts
solum74717613_solum_
solus54726983_solu_s
strums84716453_strums
stums75320083_s_tums
stylus9397463stylu_s
sulus54821883_sulu_s
sums65837583_s__ums
sylis84316023_syl_is
sylphs1435543_sylphs
sylvas12288173_sylvas
syrups11277953_syrups
vasculums1642143vasculums
vellums1235293vellums
xylems1833203_xylems
ylems1039263__ylems

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.390458182.1
2DLD Change Limit134027815.95322514.2
3Display Results81810.0302700.0
 (SQL Overall)178691816.37328038.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.