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 “gul” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

303 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
gul4583279(None) 
gal46055511gal
gel45642431gel
gulf84929421gulf
gull54828451gull
gulp75521361gulp
guls55930851guls
gum67439531gum
gun47240801gun
gut46753851gut
guv74523171guv
guy75728941guy
pul56138061pul
aal39058672aal
ague55725922ague
ail37171042ail
al210674042_al
all36148232all
auk76234142auk
auld54125362auld
awl67635302awl
bal56662722bal
bel57148462bel
bub76343982bub
bud67041272bud
bug65340742bug
buhl95518222buhl
bulb85626692bulb
bulk105426152bulk
bull65634872bull
bum75342692bum
bun56348142bun
bur55744692bur
burl64937182burl
bus56950972bus
but55963022but
buy86436542buy
caul65630002caul
cel56040552cel
col59360352col
cub76940942cub
cud67937452cud
cue57544182cue
cull65929642cull
culm85822382culm
cult66541152cult
cum76440162cum
cup76738242cup
cur56841982cur
curl66035052curl
cut57957662cut
dal47554952dal
del46752752del
dol47150652dol
dual55928172dual
dub66642202dub
dud56737592dud
due45249862due
duel56729702duel
dug58138692dug
duh77930382duh
dui46433382dui
dull56430442dull
duly85323032duly
dun46545582dun
duo48536142duo
dup67637882dup
eel37946842eel
egal55119432egal
el26745292_el
ell36735682ell
fil65447142fil
flu66530212flu
foul77027582foul
fub86337392fub
fud76335152fud
fuel76824732fuel
fug76234512fug
full75229152full
fun66841142fun
fur66637322fur
furl77030882furl
gab67155992gab
gad57556652gad
gae46457702gae
gag57753632gag
gala55635162gala
gale56347322gale
gall56335992gall
gals57946502gals
gam67060062gam
gan48060132gan
gaol56925412gaol
gap67055612gap
gar47259902gar
gas48870252gas
gat46880512gat
gaud67025432gaud
gault65128482gault
gaum75726422gaum
gaun56427712gaun
gaur56723352gaur
gay76856492gay
ged57044532ged
gee45359202gee
geld65828432geld
gels56836102gels
gelt56448012gelt
gem66840222gem
gen45950512gen
get47467462get
geum75424552geum
gey75738302gey
ghi77019882ghi
ghoul959052ghoul
gib66443532gib
gid57047272gid
gie47149542gie
gig56040752gig
gild65526512gild
gill56336182gill
gilt56348542gilt
gin46055752gin
gip67645362gip
girl56226552girl
git46266052git
glue55628492glue
glug66118012glug
glum75825102glum
glut56331292glut
gnu45522042gnu
gnus56518002gnus
go38748742g_o
goa47343802goa
goal55829302goal
gob68950892gob
god57449792god
gold65430162gold
golf85731182golf
goo47754772goo
gor47848262gor
gos47155132gos
got49870442got
gout56646002gout
gox117137182gox
goy77844552goy
grub77220082grub
grue55825712grue
gruel66014742gruel
grum75625082grum
guan55325582guan
guar56923292guar
guck114922532guck
gude65423332gude
guff114624932guff
guid66022822guid
guild75312752guild
guile64521132guile
guilt65125572guilt
gulag7310822gulag
gular6314832gular
gulch113810602gulch
gules64831042gules
gulfs94915302gulfs
gulfy124612002gulfy
gulls65222982gulls
gully94020682gully
gulps84715072gulps
gulpy114612762gulpy
gums75030942gums
gunk95423572gunk
guns55533482guns
guru54623912guru
gush85424002gush
gust55240702gust
guts56637252guts
guvs85816812guvs
guys85019642guys
gym95719062gym
gyp98319012gyp
haul75530452haul
hub86437482hub
hue66642302hue
hug76037362hug
huh96432012huh
hula74923752hula
hulk115321612hulk
hull75428782hull
hum85542932hum
hun65844712hun
hup86437812hup
hurl76029932hurl
hut66457292hut
iglu510814782iglu
ill37437092ill
jug115529542jug
jun105932062jun
jus106930222jus
jut105944012jut
kue76631862kue
lug46138062lug
lull44225762lull
lulu44122882lulu
lum55542932lum
luv67125772luv
lux106528772lux
maul64830722maul
mel56047482mel
mil55752112mil
mogul8310212mogul
mol56654592mol
mu46737482mu_
mud67336862mud
mug65837692mug
mule65236972mule
mull65128802mull
mum76643612mum
mun56143862mun
mus55946752mus
mut58357182mut
nil36144192nil
nu26331952nu_
nub56439142nub
null45125312null
nun35537742nun
nurl45327242nurl
nus37939392nus
nut36651962nut
oil37452052oil
oud47439072oud
our36042892our
out38072152out
owl66228972owl
pal56761672pal
pol56449382pol
pub76037692pub
pud65836652pud
pug65337182pug
pula65129372pula
pule65040952pule
puli65527622puli
pull64731662pull
pulp84825352pulp
puls65437562puls
pun58846512pun
pup76339882pup
pur56840552pur
purl65631422purl
pus55547842pus
put55759072put
qua124821972qua
rub56342822rub
rue35549262rue
rug46039152rug
rule49938422rule
ruly76323142ruly
rum56644642rum
run36244992run
rut35560522rut
sal36462882sal
saul45836522saul
sel38253322sel
shul75823152shul
sol37256622sol
soul46435712soul
sub55445552sub
sue35651462sue
suk75632972suk
sulk85326652sulk
sulu45128422sulu
sum56346012sum
sun37149032sun
sup57041942sup
suq126228992suq
tel35647902tel
til36350262til
tub55640032tub
tug45937402tug
tui37034022tui
tule45735872tule
tun35845192tun
tup56037542tup
tut36758092tut
tux105426572tux
ugh76520682ugh
ugly86012382ugly
uh57429852_uh
ulu36028702_ulu
um47338832_um
un28341142_un
up47832822_up
us26937432_us
ut28647032_ut
vug76127412vug
vum85428652vum
waul76927312waul
wud76227152wud
xu96018832xu_
yuk106725602yuk
yule75725142yule
yum86132822yum
yup86031702yup
zuz1110622032zuz

Search took 1 second 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 Filter178691140840.266671770.7
2DLD Change Limit140843030.32643202.5
3Display Results3033030.0634809.5
 (SQL Overall)1786913030.655272810.7
 
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.