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 “amass” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

116 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
amass7711968(None) 
admass957141admass
amahs107819061amahs
amas67746291ama_s
amiss75823071amiss
camass104114181camass
mass66044941_mass
aahs716428562a_ahs
aals49941142a_als
aas310975392a_a_s
abas68642082aba_s
abase76023482abase
abases85720772abases
abash106016512abash
abyss10669462abyss
afars85716512afars
agars66120642agars
agas55938842aga_s
agmas85919872agma_s
alans55636172alans
alas46358122ala_s
almahs118611612almahs
almas76629772alma_s
ama510853302ama__
amah98927492ama_h
amain74922912amain
amassed10388632amassed
amasser9418732amasser
amasses93912852amasses
amaze166016602amaze
amazes175613472amazes
ambos95321252ambos
amens75624842amens
amias75831472amias
amids85627512amids
amies76837692amies
amins75534322amins
amirs75924922amirs
amis66445322am_is
ammos94815822ammos
amoks11413552amoks
amps86230342am_ps
amus65529612am_us
amuse75920832amuse
amuses85117942amuses
amyls104512692amyls
anas46649862ana_s
araks94820882araks
ass37844062__ass
ataps76414832ataps
atmans84413962atmans
atmas75721012atma_s
avast85519362avast
awash116613162awash
ayahs116813522ayahs
azans146516882azans
badass949292badass
bagass938932bagass
bass66146782_bass
brass75428022brass
camas96333522cama_s
camases114216342camases
class75525482class
crass76328042crass
damans94715982damans
damars93814992damars
damask1335842damask
damasks1435072damasks
eyass84410782eyass
frass85321122frass
gamas85431362gama_s
gamays126310912gamays
glass65518132glass
grass66125202grass
hamals114816822hamals
harass9313942harass
imams91511112imams
kavass13517302kavass
kvass12507272kvass
lamas75532792lama_s
lass47444542_lass
maars74621632maars
macs86742512_macs
mads76845372_mads
maes66948402_maes
mags75444532_mags
mamas95930772mama_s
mans66354552_mans
maps86141052_maps
mars66261872_mars
mas58175822_ma_s
masa65034722_masa
masas75630412_masas
mash96039402_mash
mask105227362_mask
masks115320532_masks
massa75518922_massa
masse75125292_masse
massy104518962_massy
mast65959962_mast
masts77035762_masts
mats65460292_mats
maws96437142_maws
mays96940032_mays
mess65932432_mess
miss65339422_miss
moss67641032_moss
muss64933762_muss
omasa749482omasa
pass65239952_pass
quass144413762quass
sass45035622_sass
smash104814432smash
tamals84116632tamals
tass45640572_tass
trass56226472trass

Search took 3 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 Filter178691538000.326548131.9
2DLD Change Limit538001161.67332157.8
3Display Results1161160.0303866.7
 (SQL Overall)1786911162.02988068.5
 
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.