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

166 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
shamuses133615(None) 
amuses85117942__amuses
chamises153513312chamises
humuses1237602_humuses
rhamnuses14102312rhamnuses
shambles15159042shambles
shames114726222sham__es
shamisen1344272shamisen
shamisens1442602shamisens
shammes144312832sham_mes
shammies15259692shammies
shamus114112812shamu__s
siameses1036402siameses
statuses8409542statuses
thymuses1643072thymuses
wamuses1237022_wamuses
abacuses1235763abacuses
abuses85119103__abuses
amuse75920833__amuse_
amused94412513__amused
amuser84712623__amuser
amusers94610193__amusers
animuses1037983animuses
anuses66218773__anuses
bemuses1139293_bemuses
camases114216343_camases
camises114218463_camises
campuses1437773_campuses
causes88026473_ca_uses
cayuses12188403_cayuses
chaises124317493cha_ises
chamades16138653chamades
chamisas15317813chamisas
chamise143612853chamise_
chamisos15307423chamisos
chammies172910163chammies
chamoises16327933chamoises
chaoses124715123cha_oses
charases131312763charases
charmeuses1743093charmeuses
chases115128233cha__ses
chasses124017503cha_sses
chausses1345963chausses
chemises153211983chemises
chiauses1336483chiauses
chlamyses1962493chlamyses
choruses1339983choruses
chouses125117813ch_ouses
clauses93813323cla_uses
favuses1336183_favuses
flatuses1137173flatuses
graduses1046453graduses
grampuses1442973grampuses
hamates122917683_hamates
hames106138703_ham__es
hamulus1235323_hamulus
hanses95022633_ha_nses
hausen9610383_ha_usen
hausens1077633_ha_usens
hawses125113993_ha_wses
hiatuses1135773hiatuses
hocuses121710433_hocuses
houses96032283_h_ouses
hummuses1544453hummuses
iambuses1235783_iambuses
isthmuses1442973isthmuses
litmuses1044463litmuses
meatuses1038203meatuses
momuses1159273_momuses
muses75134303___muses
pauses84621473_pa_uses
phalluses1444263phalluses
pharoses13310323pharoses
phases114618403pha__ses
phimoses1537213phimoses
primuses1237083primuses
rhamnoses14104183rhamnoses
rhesuses1134893rhesuses
rhombuses1643293rhombuses
rhuses94911793rh__uses
salutes73716253s_alutes
sambukes1644193s_ambukes
samisen937673s_amisen
samisens1035483s_amisens
samites93118713s_amites
samosas939303s_amosas
samples112815453s_amples
saroses73619333s_aroses
sasses64124393s_a_sses
sauces84919503s_a_uces
sautes63924913s_a_utes
scampies1439333scampies
scouses93313243s_couses
seamless10238723seamless
semises93916553s_emises
shackles173010593shackles
shackoes17367853shackoes
shadbushes1951813shadbushes
shades105924533sha__des
shadufs1433673shadu_fs
shakes135024593sha__kes
shakoes144510023sha_koes
shales94731253sha__les
shamans123610903sham_ans
shamas113717943sham__as
shamble14149263shamble_
shambled16156153shambled
shame105726703sham__e_
shamed125120213sham__ed
shameless1435923shameless
shammas14358723sham_mas
shammed153911423sham_med
shammer144613143sham_mer
shammers153710843shammers
shammied16265543shammied
shammos14307203sham_mos
shamois123210423sham_ois
shamos114216983sham__os
shamosim1544753shamosim
shamoyed1744043shamoyed
shamoys15367283sham_oys
shampoos1544603shampoos
shams105829413sham___s
shandies122714113shandies
shannies113411263shannies
shanties113116593shanties
shapes115124953sha__pes
shares95236413sha__res
sharpies13411233sharpies
shaughs14245283sha_ughs
shauled1148793sha_uled
shauls94913113sha_u_ls
shaves125224933sha__ves
shavies134213213sha_vies
shikses14116573sh_ikses
shimmies15287803shimmies
shmoes114612103sh_m_oes
shmucks1833943sh_mucks
shushes133510303sh__ushes
shutes93518223sh__utes
siamese936503siamese_
sinuses73011593s_inuses
situses72710493s_ituses
smushes123710093s__mushes
soleuses838073soleuses
souses64229243s__ouses
sphygmuses216823sphygmuses
spouses92912813s_pouses
stases64225563sta__ses
statues74614903statu_es
statures83711113statures
statutes8368893statutes
styluses11204773styluses
suffuses1435833suffuses
surmises10310643surmises
swamies123712063swam_ies
taluses7311213_taluses
tamises92715973_tamises
thalluses1243903thalluses
unamused1135793unamused
uraeuses835383uraeuses
vamoses1239153_vamoses
varuses10310623_varuses
wammuses1543493wammuses
wampuses1534113_wampuses
whammies18265513whammies

Search took 9 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 Filter1786911461620.440406115.9
2DLD Change Limit1461621667.67019056.3
3Display Results1661660.0632634.9
 (SQL Overall)1786911668.17321863.6
 
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.