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

282 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
global93766(None) 
clonal8310912clonal
floral94313812floral
gimbal11228812gimbal
gleba83910242gleba_
glebae9407612glebae
glial66715432gl_ial
gloam86015942glo_am
gloat65427682glo_at
glob76623392glob__
globally1444612globally
globate1057822globate
globby1434682globby
globe84917012glob_e
globed104811762globed
globes94314542globes
globin9309722globin
globs85616402glob_s
globule1034382globule
glossal8447052glossal
glottal835102glottal
goal55829302g_o_al
goban84414072g_oban
gooral7310462gooral
goral65125752g_oral
lobar7313012_lobar
local74820272_local
loral55927822_loral
loyal84513482_loyal
aboral8314373aboral
agonal7410053agonal
alba68328333al_ba_
albas75925393al_bas
algal66518223al_gal
allobar946663allobar
alodial899953alodial
aloha8513623aloha_
alohas9411703alohas
amoral8314633amoral
anodal72512123anodal
apodal9289833apodal
atabal839743atabal
atonal6514023atonal
avowal1246323avowal
axonal1347653axonal
azonal1568273azonal
bal56662723___bal
baobab946403baobab
barbal104016663barbal
bloat75229923blo_at
blob86027093blob__
blobs95620033blob_s
blowball1544153blowball
boral75831703_boral
bromal10313653bromal
bubal94218213_bubal
cabal95222153_cabal
chloral12169983chloral
choral115118493choral
clinal8311553clinal
cloacal1135163cloacal
cloak115214013clo_ak
coal66939253_co_al
cobalt10317393_cobalt
comal95125133_comal
copal95621783_copal
coral76033453_coral
coxal146116673_coxal
cymbal15236913cymbal
diobol936883diobol
dobla84913643_dobla
domal85619203_domal
dotal64919623_dotal
float85928573flo_at
flora85317103flora_
florae94713883florae
florals104210063florals
floras94715693floras
flota85315643flota_
flotas94013003flotas
foal76630923_fo_al
focal104917673_focal
gal46055513g___al
gamba106018513gamba_
gambas115817513gambas
gambol1138223gambol
gaol56925413gao__l
gasbag1035413gasbag
gavial10310083gavial
gayal9312713g_ayal
genial74917613genial
geoidal936713geoidal
gerbil938343gerbil
ghoul959053gho_ul
gimbals12257823gimbals
gimmal11247513gimmal
gingal81010153gingal
glacial1038143glacial
glad65624013gl__ad
glam76529343gl__am
gleam86916733gl_eam
glean65818203gl_ean
glebe85016443gleb_e
glebes95512243glebes
glia56423153gl_ia_
glias64618493gl_ias
glib79421443glib__
glibly1236293glibly
glioma935953glioma_
gliomas1035333gliomas
gloams95210663gloams
gloats74515423gloats
globalise1245153globalise
globalism1445273globalism
globalist1256763globalist
globalize2144763globalize
globated1265753globated
globing113210003globing
globins10278953globins
globoid1145973globoid
globose1035543globose
globous1036503globous
globular1143383globular
globules1135413globules
globulin1144193globulin
glogg837353glo_gg
gloggs935033gloggs
glom75424383glo__m
gloms85219783glo_ms
glomus9468093glomus
gloom87116523glo_om
glooms96211683glooms
gloomy12528763gloomy
glop76724633glo__p
gloppy1454723gloppy
glops85619553glo_ps
gloria71910553gloria
glorias81610323glorias
glory96413293glo_ry
gloss64319623glo_ss
glossa7529163glossa
glossae8477283glossae
glossas8438193glossas
glossy10549003glossy
glost65422933glo_st
glosts74513813glosts
glout65925813glo_ut
glouts74414713glouts
glove94516293glo_ve
gloved114811873gloved
glover104513533glover
gloves104115183gloves
glow85222523glo__w
glowed114913833glowed
glower105114933glower
glowfly1742673glowfly
glows95518033glo_ws
gloze154815983glo_ze
glozed173711223glozed
glozes164313353glozes
glucan936183glucan
gluteal854243gluteal
glycan1234903glycan
glycol1254933glycol
glycyl1542793glycyl
goa47343803g_o_a_
goad66830983g_o_ad
goals65521293g_o_als
goas55239943g_o_as
goat56250833g_o_at
gob68950893g_ob__
gobang10376703g_obang
gobans94412043g_obans
gobble113512983g_obble
gobo76126903g_ob_o
gobos86219383g_obos
gobs76935573g_ob_s
goby106021083g_ob_y
gonad75216053g_onad
goober93911743goober
goofball1443273goofball
googol835843googol
goombah1543113goombah
goombay1543553goombay
goorals838713goorals
gorals76917653g_orals
gowan95415743g_owan
graal64316503g_raal
groan65618423gro_an
groat65531973gro_at
grovel104310543grovel
growl96115823gro_wl
gumball1266833gumball
gyoza1836113gyoza_
gyozas1933613gyozas
gyral94412783g_yral
herbal112513493herbal
horal86328683_horal
ileal56118083il_eal
ilial55317843il_ial
isobar836143isobar
joual12311653_joual
jumbal1758463jumbal
kilobar1344613kilobar
label75019383_label
labial84714343_labial
leal46043273_l_eal
legal65715943_legal
libel74116103_libel
load56730603_lo_ad
loaf76734903_lo_af
loam65630483_lo_am
loan47436453_lo_an
lob57154463_lob__
lobate82915243_lobate
lobby125113923_lobby
lobe65535363_lob_e
lobed86022133_lobed
lobes75331003_lobes
lobo67229863_lob_o
lobos75921843_lobos
lobs66441083_lob_s
lobule82910063_lobule
loca65527683_loca_
locale83915653_locale
locals83714503_locals
logan68123283_logan
loll46128383_lo_ll
loran55925093_loran
loreal63814313_loreal
losel54419423_losel
lota47233503_lota_
lotah85315853_lotah
lotas55926303_lotas
lovat8321043_lovat
lowball1275503_lowball
modal85919243_modal
molal75120343_molal
moral75533433_moral
nodal64717793_nodal
nopal75517103_nopal
notal55221353_notal
oba57531553__oba_
obas65730933__obas
obol65220613__obol
opal66923523__opal
oral47638123__oral
oval77119523__oval
phonal11310383phonal
pibal95217323_pibal
plagal948573plagal
pleonal937243pleonal
plexal1536843plexal
plical10411683plical
plural839823plural
robalo838933_robalo
royal85014703_royal
sabal75422483_sabal
sambal105215183sambal
shoal83920273sho_al
skoal93811463sko_al
slob66029423slob__
slobby1334803slobby
slobs74419873slob_s
slogan7539223slogan
soba64927923_soba_
sobas74424253_sobas
sporal82915453sporal
stomal85213313stomal
timbal102510753timbal
tombal102311023tombal
tonal53724303_tonal
total55321823_total
tribal8611133tribal
trilobal1044373trilobal
tubal75517203_tubal
tymbal13236823tymbal
verbal112513663verbal
vocal104715643_vocal
zoeal144813783_zoeal
zonal145116853_zonal
zoonal1558083zoonal

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.403443402.0
2DLD Change Limit1127162825.05022320.0
3Display Results2822820.0933032.3
 (SQL Overall)1786912825.54632219.8
 
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.