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

286 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
sylphs143554(None) 
sylph1347791sylph_
sylphy1744151sylphy
syphs13519451sy_phs
glyphs1534302glyphs
lymphs1635052lymphs
nymphs1633502nymphs
ralphs1135372ralphs
salpas85116922salpas
salps74423242salp_s
selahs9313212selahs
slypes114410482slypes
sophs104916022s_ophs
staphs114411032staphs
sulpha1135402sulpha
sulphas1236242sulphas
sylis84316022syl_is
sylphic1745882sylphic
sylphid1645962sylphid
sylphids1743952sylphids
sylphish1944272sylphish
sylvas12288172sylvas
synchs14408452synchs
synths12377882synths
syph125413272sy_ph_
alephs1136533alephs
alpha1049653_alpha
alphas1139513_alphas
alps65529243_alp_s
asylums1243633asylums
ayahs116813523ay_ahs
blahs105616513_blahs
blypes13357543blypes
bumphs15467103bumphs
bylaws14415833bylaws
caliphs1436753caliphs
caphs124515373_caphs
filths12389783filths
galahs105512683galahs
glyph1456473glyph_
graphs124510153graphs
gulps84715073gulp_s
gyps105115023gy_p_s
helps105219343help_s
humphs16528163humphs
hylas114815903hyl_as
hypes135818673hy_pes
hypha1637383hy_pha
hypos1312014743hy_pos
hyps125418413hy_p_s
kaliphs1634293kaliphs
kalpas124112943kalpas
kaphs144911503_kaphs
kelps115116423kelp_s
khaphs18394323khaphs
kophs145010933_kophs
lymph1547043lymph_
milpas101710273milpas
morphs13149433morphs
mylars114310443mylars
mynahs14416443mynahs
myopes13419963myopes
myrrhs1443603myrrhs
myths135911603my_ths
nylons9267973nylons
nymph1555213nymph_
nympha1643573nympha
nympho1643583nympho
nymphos1744083nymphos
oomphs1344723oomphs
ouphs104311273_ouphs
palps94719563palp_s
palpus104210283palpus
psychs1653653psy_chs
psyllas1244883psyllas
psyops1334343psyop_s
pulps95116483pulp_s
pylons113011243pylons
qophs19507813_qophs
ralph1078743ralph_
salads75316963salads
salals65120083salals
saleps85014903saleps
sales56055593sal_es
salmis8514273salmis
salols64017873salols
salons63823693salons
salp64534093salp__
salpa75018353salp_a
salpae84614273salpae
salpid9510883salpid
salpids1038193salpids
sals46851673sal__s
salsas65316133salsas
salts55431883sal_ts
salves94221763salves
salvos94613383salvos
samps96124673samp_s
sanghs105312073sanghs
saps65346373s_ap_s
sauchs115112233sauchs
saughs104812053saughs
scalps104315233scalp_s
scapes105122263scapes
scarphs14437413scarphs
scopes104719593scopes
scops95820193scop_s
sculps104611753sculp_s
sculpts11377063sculpts
scups95316653scup_s
scyphi1643173scyphi
scyphus1743203scyphus
seeps74828753seep_s
selah8319613selah_
selfs85220243sel_fs
selles64426983selles
sells55134433sel_ls
sels46345983sel__s
selvas93812913selvas
selves94119613selves
septs75420603s_epts
seraphs12408093seraphs
shahs115919513s_hahs
shapes115124953shapes
ships105123773ship_s
shlepps14394833shlepps
shleps114710333shleps
shlubs11386733shlubs
shops104222903shop_s
sighs95416743s_ighs
silds65520523sil_ds
silks94620683sil_ks
sills55135993sil_ls
silos56029433sil_os
silts55330823sil_ts
silvas92912183silvas
simps94719763simp_s
sinhs86719603s_inhs
sipes76036953s_ipes
sips65740103s_ip_s
sixths16416373sixths
skelps12407923skelp_s
skeps115614253skep_s
skips115616603skip_s
skyphos1963733skyphos
slabs75322643s_labs
slags66525903s_lags
slams74927903s_lams
slaps76025713s_laps
slash84719683s_lash
slats55436903s_lats
slaws85222713s_laws
slays85723683s_lays
sleds64418853s_leds
slews86220353s_lews
slims75423653s_lims
slipes84921413slipes
slips76023723s_lips
slits56128853s_lits
slobs74419873s_lobs
sloes54728873s_loes
slogs64521843s_logs
slopes84820453slopes
slops75026013s_lops
slosh84514483s_losh
sloths94911893sloths
slots54830533s_lots
slows85323463s_lows
slubs74719533s_lubs
slues54527173s_lues
slugs64618563s_lugs
slums74623433s_lums
slurs54123373s_lurs
slush85316573s_lush
sluts54523983s_luts
slype105112363slyp_e
smiths114711023smiths
snaps74719563snap_s
snaths95112913snaths
snipes83917393snipes
snips75818013snip_s
soaps75120713soap_s
solans64122493solans
soles55547923sol_es
soleus64615613soleus
solids74116403solids
solons65120023solons
solos54830793sol_os
sols45448163sol__s
solums85211333solums
solus54726983sol_us
solves95018223solves
sooths95715593sooths
soph97024203s_oph_
sophy136611763s_ophy
sops65244563s_op_s
soths86218633s_oths
soughs105115623soughs
soups75322943soup_s
souths95216603souths
spas67036723s__pas
spilths12356023spilths
splash1168823splash
splats84817303splats
splays114910873splays
splits85416413splits
splosh1186543splosh
stapes85028733stapes
staph104314653staph_
steps76619883step_s
stichs114511653stichs
stipes84524053stipes
stopes84525893stopes
stops74827283stop_s
stupas83910883stupas
stupes84116953stupes
stylers10359353stylers
styles94418653styl_es
stylets10369213stylets
stylish13197443stylish
stylus9397463styl_us
subahs114512383subahs
sughs95313323s_ughs
sulcus8410493sulcus
sulfas9311563sulfas
sulks94818463sul_ks
sulphid1346113sulphid
sulphids1444373sulphids
sulphur12123873sulphur
sulphurs1383653sulphurs
sulus54821883sul_us
sumps95023433sump_s
supes75628303s_upes
sups64834433s_up_s
surahs94515543surahs
swaps104819203swap_s
swaths125312643swaths
swipes114114333swipes
swops105913973swop_s
syboes1139343syboes
sycees11409653sycees
syces106416463sy_ces
sykes124816863sy_kes
syli74318983syl__i
sylva11268443syl_va
sylvae12236863sylvae
sylvan12257363sylvan
sylvans13235893sylvans
sylvin12247303sylvin
sylvins13246243sylvins
synch135011793synch_
syncs104610173sy_ncs
syngas10368913syngas
synods1077953synods
synth113711823synth_
sypher14317083sy_pher
syphers15317273sy_phers
syphon1436853sy_phon
syphons1537503sy_phons
syrens94911993syrens
syrphid1646103syrphid
syrphids1744243syrphids
syrups11277953syrups
sysops1136013sysops
tilths9459373tilths
tophs105220053_tophs
types105721063ty_pes
typhus14395713ty_phus
typos106015813ty_pos
typps12549303ty_pps
wyles114615323wyl_es
xylans1635883xylans
xylems1833203xylems
xylols1634173xylols
xylyls1931833xylyls
yaps95933523_yap_s
yeahs115214553_yeahs
yechs136112583_yechs
yelps105712993yelp_s
yeps95924403_yep_s
yipes106017843_yipes
yips95226703_yip_s
ylems1039263_ylems
yodhs12669013_yodhs
yoghs125410593_yoghs
yups96121603_yup_s

Search took 6 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 Filter1786911127160.423422437.4
2DLD Change Limit1127162865.26321416.7
3Display Results2862860.0803575.0
 (SQL Overall)1786912865.76630990.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.