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

239 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
guys8501964(None) 
buys95726791buys
gays87338021gays
goys86328411goys
guls55930851guls
gums75030941gums
guns55533481guns
guts56637251guts
guvs85816811guvs
guy75728941guy_
abys97221882abys
agues64919052agues
auks85525262auks
ays67050292_ays
bays97143912bays
beys913829552beys
boys96737332boys
bubs86235502bubs
buds75235172buds
bugs76035912bugs
bums85934592bums
buns66243722buns
buoys104810632buoys
burs65847422burs
bus56950972bu_s
buss65134912buss
busy94727172busy
buts67247692buts
buy86436542buy_
bys85229462_bys
cays95437672cays
coys97537242coys
cubs85832382cubs
cuds76730472cuds
cues65438982cues
cups85430822cups
curs65645542curs
cuss65430612cuss
cuts65841152cuts
days87637132days
deys85027472deys
drys86314802drys
dubs78432192dubs
duds65530142duds
dues56045502dues
dugs614832282dugs
duns55140432duns
duos56728132duos
dups75929512dups
fays108535362fays
foys105628292foys
fubs96328792fubs
fuds86528562fuds
fugs85730692fugs
funs75235732funs
furs76735042furs
fuss76027932fuss
gabs76740422gabs
gads67843382gads
gaes56348032gaes
gags66441062gags
gals57946502gals
gams76648882gams
gaps76042972gaps
gars55750742gars
gas48870252g_as
gats56753442gats
gauds75717722gauds
gaums86217072gaums
gaurs66317992gaurs
gauss65613452gauss
gay76856492gay_
geds66730812geds
gees55647882gees
gels56836102gels
gems75329112gems
gens55740072gens
gets55442482gets
geums85414112geums
gey75738302gey_
ghis85020162ghis
gibs75529272gibs
gids65933742gids
gies55641422gies
gigs66631182gigs
gins55543952gins
gips75632922gips
gits55744592gits
gleys96514852gleys
glues65125682glues
glugs75214282glugs
glums84621422glums
gluts66120132gluts
gnus56518002gnus
goas55239942goas
gobs76935572gobs
gods65438042gods
goes55644092goes
goos57644912goos
gos47155132g_os
gouts64826172gouts
goy77844552goy_
grays95621332grays
greys96614852greys
grubs86312602grubs
grues65721962grues
guan55325582guan
guans64419442guans
guar56923292guar
guars65021052guars
guck114922532guck
gucks123917302gucks
gude65423332gude
gudes74520812gudes
guess64213362guess
guest65225922guest
guff114624932guff
guffs124414822guffs
guid66022822guid
guids75516152guids
guise64717712guise
gul45832792gu_l
gules64831042gules
gulf84929422gulf
gulfs94915302gulfs
gull54828452gull
gulls65222982gulls
gulp75521362gulp
gulps84715072gulps
gum67439532gu_m
gun47240802gu_n
gunk95423572gunk
gunks104517722gunks
gursh94512332gursh
guru54623912guru
gurus64318192gurus
gush85424002gush
gussy95314322gussy
gust55240702gust
gusts65722792gusts
gut46753852gu_t
gutsy96412842gutsy
guv74523172gu_v
guyed1049892guyed
guyot9314522guyot
guyots1036002guyots
gym95719062g_ym
gyms107514592gyms
gyp98319012g_yp
gyps105115022gyps
hays106138072hays
hoys107733932hoys
hubs96027142hubs
hues75235232hues
hugs86129752hugs
hums96831422hums
huns76136932huns
huts76737442huts
jays146328342jays
joys146624662joys
jugs125525602jugs
jus106930222ju_s
juts115930162juts
kays116032192kays
keys116322162keys
kues86426772kues
kumys1435932kumys
lays76043252lays
leys76430182leys
lues45943552lues
lugs55233522lugs
lums65734242lums
luvs75818502luvs
mays96940032mays
muds75530652muds
mugs76232042mugs
mums85732772mums
muns65535922muns
mus55946752mu_s
muss64933762muss
muts64839982muts
nays75931592nays
nubs65927142nubs
nuns45228232nuns
nus37939392nu_s
nuts45032672nuts
ouds56430102ouds
ours47237562ours
outs45746962outs
pays95940222pays
pubs85029212pubs
puds75630512puds
pugs76332772pugs
puls65437562puls
puns66641482puns
pups86032232pups
purs65641042purs
pus55547842pu_s
puss64830132puss
puts65641752puts
quays174612042quays
queys17398362queys
rays77642352rays
rubs66133492rubs
rues46044482rues
rugs56033682rugs
rums64833472rums
runs46438082runs
ruts44541492ruts
says75942102says
soys75233932soys
subs66037122subs
suds56135292suds
sues46247652sues
suks85927122suks
sums65837582sums
suns45841902suns
sups64834432sups
suqs134319652suqs
suss45229302suss
toys78036342toys
tubs65430062tubs
tugs56231672tugs
tuis44829642tuis
tuns45138662tuns
tups65628762tups
tuts45838452tuts
ughs85410972ughs
uns35936762_uns
ups55629052_ups
us26937432_u_s
uts35534372_uts
vugs87022872vugs
ways107737952ways
whys137011662whys
wuss75219332wuss
yays105728912yays
yuks116418022yuks
yups96121602yups

Search took 2 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 Filter178691298720.563317390.8
2DLD Change Limit298722391.25023897.6
3Display Results2392390.0603983.3
 (SQL Overall)1786912391.87395403.6
 
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.