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

211 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
glyphs153430(None) 
glyph1456471glyph_
alephs1136532alephs
blypes13357542blypes
glops85619552glop_s
glyphic1844062glyphic
graphs124510152graphs
gyps105115022g_yp_s
lymphs1635052_lymphs
slypes114410482slypes
sylphs1435542sylphs
syphs13519452_syphs
aleph10311393aleph_
aliyahs13395323aliyahs
almahs118611613almahs
almehs11619493almehs
alpha1049653al_pha
alphas1139513al_phas
alps65529243al_p_s
anaglyphs1851543anaglyphs
ayahs116813523_ayahs
blahs105616513bl_ahs
blips95615783blip_s
blype12429673blyp_e
bumphs15467103bumphs
caliphs1436753caliphs
caphs124515373_caphs
clachs133511323clachs
claps95626183clap_s
clepes104214623clepes
clips96018303clip_s
clops95924853clop_s
cloths115512483cloths
clypei1334163clypei
clypeus1433243clypeus
coypus13389303coypus
crypts13397743crypts
elopes85918163elopes
flaps105621383flap_s
flips105117743flip_s
flops105920143flop_s
flybys1792773flybys
flyers125712803flyers
flypast1583753flypast
flytes123911563flytes
galahs105512673galahs
galops94712623galop_s
galumphs1642023galumphs
galyacs1335273galyacs
galyaks1534623galyaks
gamps105323713gamp_s
gapes86030823g_apes
gaps76042973g_ap_s
garths104111503garths
gasps85415483gasp_s
gawps115911013gawp_s
gayals1039513gayals
gays87338023gay__s
gerahs1039413gerahs
ghylls1335143ghylls
gimps105915203gimp_s
gips75632923g_ip_s
girths105612273girths
glaces94218023glaces
glacis94012133glacis
glades84820343glades
glads75620613gl_ads
glairs75211333glairs
glams85822933gl_ams
glands85314403glands
glans65125833gl_ans
glares75518863glares
glass65518133gl_ass
glazes165315643glazes
gleams94812253gleams
gleans75014743gleans
glebes95512243glebes
gledes84915133gledes
gleds75417893gl_eds
gleeds84711623gleeds
gleeks11489673gleeks
glees65027593gl_ees
gleets75315053gleets
glens66519853gl_ens
gleys96514853gl_eys
glias64618493gl_ias
glides84518863glides
gliffs13436323gliffs
glimes94717523glimes
glims87417673gl_ims
glints75714213glints
gloams95210663gloams
gloats74515423gloats
globes94314543globes
globs85616403gl_obs
gloggs935033gloggs
gloms85219783gl_oms
glomus9468093glomus
glooms96211683glooms
glop76724633glop__
gloppy1454723gloppy
gloss64319623gl_oss
glosts74513813glosts
glouts74414713glouts
gloves104115183gloves
glows95518033gl_ows
glozes164313353glozes
gluers75011153gluers
glues65125683gl_ues
glugs75214283gl_ugs
glumes94516813glumes
glums84621423gl_ums
gluons738503gluons
glutes74517673glutes
gluts66120133gl_uts
glycan1234903glycan
glycans1344233glycans
glycin1235963glycin
glycins1335563glycins
glycol1254933glycol
glycols1344133glycols
glycyl1542793glycyl
glycyls1642063glycyls
glyptic1544503glyptic
glyptics1643103glyptics
gonophs1344453gonophs
goops86620963goop_s
gorps85316993gorp_s
goths96513003g_oths
goyish13379013goyish
goys86328413goy__s
grapes95123123grapes
graph115315613graph_
gripes94619873gripes
grips85520133grip_s
griths105211653griths
gropes95220403gropes
gryphon1643873gryphon
gryphons1743963gryphons
gulps84715073gulp_s
guyots1036003guyots
guys85019643guy__s
gybes115012723g_ybes
gyms107514593g_y_ms
gyp98319013g_yp__
gypsy14636993g_ypsy
gyres94820323g_yres
gyros95616483g_yros
gyrus95310803g_yrus
gyves125711553g_yves
humphs16528163humphs
hypes135818673_hypes
hypha1637383_hypha
hypos1312014743_hypos
hyps125418413_hyp_s
kaliphs1634293kaliphs
kaphs144911503_kaphs
khaphs18394323khaphs
klepht1535043klepht
klephts1642183klephts
kophs145010933_kophs
lakhs125210343_lakhs
lapis76223153_lapis
laps66848873_lap_s
laths86022403_laths
lips67141443_lip_s
lochs106715513_lochs
lopes76437343_lopes
lops66043353_lop_s
lupus74512523_lupus
lych126015763_lych_
lyches144213613_lyches
lyes75530833_ly_es
lymph1547043_lymph_
lyres85019963_lyres
lyses84518253_lyses
lysis84511463_lysis
morphs13149433morphs
myths135911603_myths
nymphs1633503nymphs
oomphs1344723oomphs
ouphs104311273_ouphs
plops95920333plop_s
plyers114912983plyers
polyps13479763polyp_s
polypus14346933polypus
psychs1653653psychs
qophs19507813_qophs
ralphs1135373ralphs
rayahs12579193rayahs
scyphi1643173scyphi
scyphus1743203scyphus
skyphos1963733skyphos
slaps76025713slap_s
slipes84921413slipes
slips76023723slip_s
slopes84820453slopes
slops75026013slop_s
sloths94911893sloths
slype105112363slyp_e
sophs104916023_sophs
staphs114411033staphs
sylph1347793sylph_
sylphy1744153sylphy
syph125413273_syph_
tophs105220053_tophs
triglyphs1851603triglyphs
types105721063_types
typhus14395713_typhus
typos106015813_typos
typps12549303_typps

Search took 5 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.1431249587.4
2DLD Change Limit1127162114.43625409.4
3Display Results2112110.0633349.2
 (SQL Overall)1786912114.64238494.4
 
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.