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

228 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
shamoys1536728(None) 
shamois123210401shamois
shamos114216981shamo_s
shamoy14379911shamoy_
chamois143512172chamois
savoys12427892s_avoys
shadows1437192shadows
shakoes144510012shakoes
shakos134912182shako_s
shaloms1288982shaloms
shamans123610892shamans
shamas113717932sham_as
shames114726222sham_es
shammas14358712shammas
shammes144312832shammes
shammos14307202shammos
shammy16388502shammy_
shamoyed1744042shamoyed
shampoos1544602shampoos
shams105829412sham__s
shamus114112812sham_us
shays116021432sha__ys
shmoes114612092sh_moes
agamous1037923agamous
alamos8415003alamo_s
amoks11413553__amoks
camos95927613_camo_s
chadors1338723chadors
chammy18488953chammy_
chamoix21275623chamoix
champs154915683cham_ps
champy18509613champy_
chams126028503cham__s
chanoyu1544483chanoyu
chanoyus1643913chanoyus
chaos105622863cha_o_s
charpoys1834533charpoys
chays135319743cha__ys
chemos13311723chemo_s
chlamys1733783chlam_ys
chymous1775683chymous
clamors11710093clamors
enamors939123enamors
famous11412393_famous
gamays126310903_gamays
glamors1068113glamors
haloes94623863_haloes
halons95720713_halons
halos85230253_halo_s
hamals114816813_hamals
hames106138703_ham_es
hammy155113433_hammy_
hams96446133_ham__s
hamzas20119013_hamzas
havocs1435653_havocs
haymows1883813_haymows
hays106138073_ha__ys
homeys145012873_homeys
homos105921783_homo_s
hoys107733933_h__oys
humors11129633_humors
mameys13449523_mameys
pharos11312063pharo_s
ramous8417103_ramous
rhamnus1233133rhamnus
sabots8314693s_abots
sagos66123873s_ago_s
sajous13310583s_ajous
salmons93713253salmons
salols64017873s_alols
salons63823683s_alons
sambas104219263s_ambas
sambos104315193s_ambos
sameks12409323s_ameks
samosa8510203s_amosa
samosas939293s_amosas
samoyed1335893s_amoyed
samoyeds1442663s_amoyeds
samps96124673s_am_ps
sapors84118813s_apors
sarods74918573s_arods
saros55238063s_aro_s
satays94411683s_atays
savors95616103s_avors
savoy114713883s_avoy_
says75942103s_a__ys
scamps125014173scam_ps
scams94423973scam__s
schmoes14308543schmoes
schmoos14347513schmoos
schmos13379153schmo_s
seadogs958643seadogs
seamers94719433seamers
seams75731663seam__s
seamy105921273seam_y_
seasons72614233seasons
seaways13307513seaways
sepoys1138473s_epoys
sermons9311783sermons
shabby1635803shabby_
shackoes17367853shackoes
shackos16429023shackos
shacks154817563sha_cks
shaders115915553shaders
shades105924533sha_des
shadoof1446133shadoof
shadoofs1554233shadoofs
shadow1337253shado_w
shadowy1744723shadowy
shads95124483sha__ds
shadufs1433673shadufs
shady125416513sha_dy_
shafts125411433sha_fts
shaggy14478043shaggy_
shags95123863sha__gs
shahdoms1743773shahdoms
shahs115919513sha__hs
shairds11216263shairds
shairns10276783shairns
shakers144015563shakers
shakes135024593sha_kes
shako125516083shako__
shaky154616843sha_ky_
shales94731253sha_les
shaley123714993shaley_
shallops13288313shallops
shallots11319493shallots
shallows14388853shallows
shalom11810913shalo_m
shaly114322863sha_ly_
sham96436353sham___
shaman113314273sham_an
shamble14149263shamble
shambles15159043shambles
shame105726703sham__e
shamed125120213sham_ed
shaming133016743shaming
shammash18293743shammash
shammed153911423shammed
shammer144613143shammer
shammers153710833shammers
shammies15259673shammies
shamosim1544723shamosim
shamoying1844523shamoying
shampoo1435373shampoo
shamrock1943473shamrock
shamrocks2043033shamrocks
shamuses1336153shamuses
shandy134710033shandy_
shanks135315583sha_nks
shanny124110093shanny_
shanteys14395503shanteys
shantis103313083shantis
shanty124715113shanty_
shapers124016893shapers
shapes115124943sha_pes
shards104319173sha_rds
sharers104720623sharers
shares95236413sha_res
sharias102516003sharias
sharifs13279903sharifs
sharks135019723sha_rks
sharns95516983sha_rns
sharny124711833sharny_
sharps115516083sha_rps
sharpy145211033sharpy_
shaughs14245283shaughs
shauls94913113sha_uls
shavers134115093shavers
shaves125224933sha_ves
shavies134213203shavies
shawls125411973sha_wls
shawms14579563sha_wms
shaws116226263sha__ws
shay107133343sha__y_
sheols94614153sh_eols
shimmy16306413shimmy_
shims104422543shim__s
shindys14314133shindys
shmo95318093sh_mo__
shnooks1485573shnooks
shoes85429653sh__oes
shogs95319703sh__ogs
sholoms1278013sholoms
shooks134515623sh_ooks
shools94919003sh_ools
shoos84226353sh__oos
shoots94619343sh_oots
shopboys1843273shopboys
shops104222893sh__ops
shots84730833sh__ots
shows115324573sh__ows
shoyu1138903sh__oyu
shoyus1265993sh__oyus
sixmos1534813sixmo_s
sjamboks2342233sjamboks
skatols1135523skatols
skimos12548803skimo_s
slaloms9106543slaloms
slams74927903slam__s
slaveys13415203slaveys
slays85723683sla__ys
smogs85112163s__mogs
soys75233933s___oys
spambots1443313spambots
spams94922193spam__s
spays105520513spa__ys
spumous1135853spumous
squamous1944663squamous
stamens93411483stamens
stamps105614023stam_ps
stanols739733stanols
stators73915553stators
stays86022023sta__ys
stroys95914603s_troys
summons1158003summons
sumos75720093s_umo_s
swamies123712063swamies
swamis114212293swam_is
swamps135910263swam_ps
swampy16437233swampy_
swamy136714403swam_y_
sways115518463swa__ys
teapoys1235963teapoys
thymols1533843thymols
whammy19375293whammy_
whamo135511263whamo__
whams135515643wham__s

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 Filter1786911340270.296603685.8
2DLD Change Limit1340272287.86017051.8
3Display Results2282280.0763000.0
 (SQL Overall)1786912288.23221706.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.