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

120 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
samshus1212535(None) 
samshu11134621samshu_
saddhus1243672saddhus
sadhus10298462sa_dhus
sambhur1453082sambhur
sambhurs1543182sambhurs
sashes94728482sa_shes
smashes123914612smashes
smashup1443452smashup
smashups1543212smashups
amahs107819063_amah_s
amicus103810003_amicus
amus65529613_am__us
ascus75013583_a_scus
ashes86230613_a_shes
bashes115631393ba_shes
caestus947773caestus
campus125213923cam_pus
canthus1248713canthus
cashes114729883ca_shes
casus76419253ca_s_us
damsels10126703damsels
damsons1038013damsons
dashes106124983da_shes
dashis104414393da_shis
famishes1658283famishes
famous11412393fam_ous
famulus1235043famulus
fashes124524023fa_shes
gamashes1456953gamashes
gashes105725153ga_shes
hamulus1235323hamulus
hashes125024803ha_shes
iambus10468903iam_bus
kamsins1346963kamsins
kashas133311903ka_shas
lapsus8437273laps_us
lashes94831003la_shes
marshes123615373marshes
mashes115030003ma_shes
pashas115117063pa_shas
pashes115828393pa_shes
passus83610293pa_ssus
ramous8417113ram_ous
ramsons939563ramsons
ramus76418283ram__us
rashes95330153ra_shes
saddhu1133413saddhu_
sadhes104715373sa_dhes
sadhu9459963sa_dhu_
sajous13310583sa_jous
salsas65316133sals_as
samadhis1444253samadhis
samaras9312913samaras
sambals115213483sambals
sambars115113843sambars
sambas104219263sam_bas
sambhar1444853sambhar
sambhars1544833sambhars
sambos104315193sam_bos
sambur10469503sam_bur
samburs11369343samburs
samechs14285353samechs
samekhs16303923samekhs
sameks12409323sam_eks
samiels939763samiels
samisens1035483samisens
samites93118713samites
samlets93813553samlets
samosas939293samosas
sampans112411003sampans
samples112815453samples
samps96124673sam__ps
samsara936913samsara
samsaras1045873samsaras
sandhis1139993sandhis
sanghs105312063sangh_s
sanious7514103sanious
sansars73313913sansars
sanseis73011603sanseis
sarcous9312933sarcous
sardius839553sardius
sarsars73512143sarsars
sarsens7311393sarsens
sash77235303sa_sh__
sashay1238363sa_shay
sashays1336333sa_shays
sashed105622943sa_shed
sasins64923103sa_sins
sass45035623sa_s__s
sasses64124393sa_sses
sassies74719263sassies
sauchs115112233sauch_s
saughs104812053saugh_s
scyphus1743203scyphus
shamus114112813sham__us
shushes133510303shushes
simious939803simious
skoshes14246253skoshes
slashes103619113slashes
sloshes103811803sloshes
slushes103514413slushes
smash104814433smash__
smashed133711223smashed
smasher123911023smasher
smashers13339593smashers
smushes123710093smushes
snashes105214753snashes
stashes103916173stashes
sushis9311183s_ushis
swashes134714403swashes
swishes133411373swishes
tamashas13135683tamashas
tarsus6310513tars_us
wammus13426733wam_mus
wampus13499013wam_pus
wamus105514683wam__us
washes124425493wa_shes
washup1435323wa_shup
washups1534683wa_shups

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.423422437.4
2DLD Change Limit1340271207.45317983.0
3Display Results1201200.0304000.0
 (SQL Overall)1786911207.90622601.9
 
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.