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

172 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
ashrams123665(None) 
ashram1139051ashram_
asarums9467612asarums
ashcans1235182ashcans
ashlars10297062ashlars
ashtrays14534202ashtrays
asrama839192as_rama
asramas938302as_ramas
astrals75515242astrals
ihrams1137172_ihrams
scrams105216622_scrams
shams105829412_sh_ams
washrags1543892washrags
affrays1644063affrays
aghas97014873agh_a_s
agoras7613343agora_s
alarms85913053alar_ms
alarums9408923alarums
amtracs1198883amtracs
anagrams1146593anagrams
anoraks1137603anoraks
antrums969173antrums
anurans73810553anurans
araks94820883a__raks
arame75026623a__rame
arames84622573a__rames
arhats9312973arh_ats
arms66137493a__r_ms
arras55626133a_rra_s
arrays95311683a_rrays
arums75517833a__rums
asanas6514113asana_s
asarum84610913asarum_
ascaris93613323ascaris
ashamed1336243ash_amed
ashcake1663373ashcake
ashcakes1753733ashcakes
ashcan1135843ashca_n
ashes86230613ash__es
ashfall1343943ashfall
ashfalls1443433ashfalls
ashlar9338193ashla_r
ashlers10319583ashlers
ashless10318453ashless
ashman1148383ashma_n
ashtray13805553ashtra_y
assais6711963as_sais
assays977903as_says
asthmas12117363asthma_s
astral66919283astra_l
astray95615543astra_y
aswarm11107913aswarm_
asylums1243633asylums
auras55932563a_ura_s
aurums849383a_urums
australs8359533australs
bashaws15347713bash_aws
cashaws15398573cash_aws
chams126028503_ch_ams
charms135218843_charms
crams96229153__crams
dirams94413703_dirams
dirhams13376313dirhams
dishrags1346203dishrags
drams86025833__drams
engrams1038073engrams
estrays10529403estrays
estrums9208603estrums
forams115115913_forams
grams85327313__grams
hams96446133__h_ams
harms106829013__harms
ihram10310183_ihram_
isograms1146473isograms
jorams154810533_jorams
kashas133311903kash_a_s
kashruts1542793kashruts
lashkars1543673lashkars
mantrams12288963mantrams
marrams11310123marrams
mihrabs1444203mihrabs
oghams1245853ogh_ams
pangrams1337153pangrams
pashas115117063pash_a_s
pastrami1246333pastrami
pastramis1345683pastramis
prams96125513__prams
pshaws14435703psh_aws
rams65950773___rams
sabras85116363sabra_s
sacrals93311793sacrals
sacrums11388043sacrums
salaams997703salaams
sarans64224433_sarans
sashays1336333sash_ays
satraps95011643satraps
scams94423973_s_cams
scrags95713803_scrags
scram910621623_scram_
scraps106017243_scraps
screams114810623_screams
scrims104615933_scrims
scrums104614253_scrums
seams75731663_s_eams
seracs84418573_seracs
serais64326133_serais
serums83916303_serums
shads95124483_sh_ads
shags95123863_sh_ags
shahs115919513_sh_ahs
sham96436363_sh_am_
shamas113717943_sh_amas
shame105726703_sh_ame
shames114726223_sh_ames
shamos114216983_sh_amos
shamus114112813_sh_amus
shards104319173_shards
shares95236413_shares
sharks135019723_sharks
sharns95516983_sharns
sharps115516083_sharps
shawms14579563_shawms
shaws116226263_sh_aws
shays116021433_sh_ays
sheafs124912883_sheafs
sheals94420643_sheals
shears93820903_shears
sheas86331793_shea_s
shims104422553_sh_ims
shnaps1148083_shnaps
shoals94215793_shoals
shoats94117083_shoats
shorans102812413_shorans
shrank13359123_shrank
shreds105613053_shreds
shrews129313923_shrews
shrimp13478773_shrimp
shrimps14516753_shrimps
shris84221453_shr_is
shrubs11409213_shrubs
shrugs10469163_shrugs
shwas116415103_shwa_s
slams74927903_s_lams
smarms105712533_smarms
soras55041013_sora_s
spams94922193_s_pams
sprags95715823_sprags
sprats85819933_sprats
sprays115913643_sprays
steams84916903_steams
straps87721783_straps
strass67117223_strass
straws98718673_straws
strays96417933_strays
streams94713373_streams
strums84716453_strums
surahs94515543_surahs
suras55336333_sura_s
swarms116112173_swarms
tangrams1136163tangrams
tharms115712243_tharms
thirams1236823thirams
thraws129211103_thraws
thrums11429123_thrums
trams75327673__trams
washdays1842863washdays
washrag1444043washra_g
washrooms1743953washrooms
whams135515643_wh_ams
yashmacs1842103yashmacs
yashmaks2042463yashmaks
zirams17438643_zirams

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 Filter1786911340270.406440125.6
2DLD Change Limit1340271727.36018210.2
3Display Results1721720.0632730.2
 (SQL Overall)1786911727.82922824.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.