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

213 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
ashlars1029706(None) 
ashlar9338191ashlar_
ashlers10319581ashlers
ashcans1235182ashcans
ashlared1253932ashlared
ashler9459972ashler_
ashless10318452ashless
ashrams1236652ashrams
lashkars1543672lashkars
shears93820902_shears
abhors11410623abh_ors
afars85716513a__fars
agars66120643a__gars
aghas97014873agh_a_s
aglare7312423a_glare
akelas10311193akela_s
alans55636173a__lans
alar46340073a__lar_
alarm76621423a__larm
alarms85913053a__larms
alary86123443a__lary
alas46358123a__la_s
alegars838933alegars
allays94313743a_llays
altars64518153a_ltars
alular6311353alular_
amblers115213563amblers
anears63717183a_nears
anglers84014823anglers
anlas55626933a_nla_s
antiars7314623antiars
antlers74014743antlers
appears11308953appears
arhats9312973arh_ats
arrears738843arrears
asanas6514113asana_s
ascaris93613323as_caris
ashcake1663373ashcake
ashcakes1753733ashcakes
ashcan1135843ashca_n
ashes86230613ash__es
ashfall1343943ashfall
ashfalls1443433ashfalls
ashier94714833ashier_
ashlaring1344493ashlaring
ashlered1244623ashlered
ashman1148383ashma_n
ashore9414613ash_ore
ashplant1345413ashplant
ashplants1443533ashplants
ashram1139053ashra_m
ashtray13805553ashtray
ashtrays14534203ashtrays
askers105915403as_kers
aslant6317753as_lant
aspers86220313as_pers
asphalts1344183asphalts
assais6711963as_sais
assays977903as_says
asters65631603as_ters
asthmas12117363asthma_s
astrals75515243astrals
astylar10265063astylar_
aswarm11107913as_warm
asyla839333asyla__
asylums1243633asylums
athwart1348683athwart
atlas55821583a_tla_s
attars64515313a_ttars
avatars1036443avatars
axillars15235993axillars
bashaws15347713bash_aws
bashers124820833bash_ers
bashlyks2041973bashlyks
basilar937303basilar_
basilary1345063basilary
cashaws15398573cash_aws
cashiers13318883cashiers
cashless1336773cashless
cellars93713693cellars
chars105936643_ch_ars
collars93816573collars
dashers115016863dash_ers
dollars83311023dollars
escars83913133es_cars
eschars1237183eschars
escolars1045343escolars
eskars10357593es_kars
haars85620473__haars
hears86737373__hears
hoars85925553__hoars
insulars8137323insulars
isobars936593isobars
kashas133311903kash_a_s
kashers143914023kash_ers
kashmirs17132243kashmirs
lahars94013163lah_ars
lars46956573___lars
lascars979013las_cars
lashers104121833lash_ers
lashkar1443703lashkar_
malars85020683_malars
masalas9312053masala_s
mashers124621053mash_ers
medlars10259443medlars
mishears1338323mishears
molars85517323_molars
mylars114310443_mylars
oculars948363oculars
ostlers72911203ostlers
pashas115117063pash_a_s
pedlars103210213pedlars
pillars9313493pillars
polars84419353_polars
poplars113910333poplars
pshaws14435703psh_aws
psywars1533673psywars
rashers104020913rash_ers
rehears103312773rehears
saggars93610683saggars
sahuaro1044233sahuaro
sahuaros1154283sahuaros
sailers73822323sailers
sailors73213723sailors
salads75316963_salads
salals65120083_salals
salary9515213_salary
sambars115113843sambars
sangars83116253sangars
sansars73313913sansars
sardars83112903sardars
sarsars73512143sarsars
sashays1336333sash_ays
sashless1136603sashless
scalars93711903scalars
scars75433533_s_cars
scholars1336683scholars
sears54744913_s_ears
selahs9313213_selahs
sewars94018633_sewars
shads95124483_sh_ads
shags95123863_sh_ags
shahs115919513_sh_ahs
shales94731253_shales
shams105829413_sh_ams
shard96125963_sh_ard
shards104319173_sh_ards
share86437083_sh_are
shares95236413_sh_ares
shark126225023_sh_ark
sharks135019723_sh_arks
sharn84823703_sh_arn
sharns95516983_sh_arns
sharp104922533_sh_arp
sharps115516083_sh_arps
shaws116226263_sh_aws
shays116021433_sh_ays
sheafs124912883_sheafs
sheals94420643_sheals
shear85424833_shear_
sheas86331793_shea_s
sheers94322403_sheers
shiers94921753_shiers
shikars1436183_shikars
shirrs94413173_shirrs
shleps114710333_shleps
shlubs11386733_shlubs
shmears1277073_shmears
shnaps1148083_shnaps
shoals94215793_shoals
shoats94117083_shoats
shoers94518333_shoers
shofars1335833_shofars
shwas116415103_shwa_s
shyers124712203_shyers
simars84916933_simars
sitars65417593_sitars
sizars154812623_sizars
slabs75322643_s_labs
slags66525903_s_lags
slams74927903_s_lams
slaps76025713_s_laps
slats55436903_s_lats
slaws85222713_s_laws
slays85723683_s_lays
slurs54123373_s_lurs
smears84714433_smears
soars54732513_s_oars
sofars94712783_sofars
solans64122493_solans
solar55927343_solar_
sonars64818973_sonars
sowars94318013_sowars
spars75431543_s_pars
spears84019473_spears
splats84817303_splats
splays114910873_splays
stars55836573_s_tars
sugars7312423_sugars
swears94114073_swears
talars66021683_talars
taskbars1452993taskbars
tolars64817943_tolars
tsars56717113ts__ars
uhlans937573_uhlans
ushers94415533ush_ers
uvulars1044413uvulars
velars93913723_velars
washdays1842863washdays
washers134517523wash_ers
washrags1543893washrags
yashmacs1842103yashmacs
yashmaks2042463yashmaks

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.420425454.8
2DLD Change Limit1340272136.90619407.3
3Display Results2132130.0633381.0
 (SQL Overall)1786912137.38924183.4
 
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.