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

287 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
guy7572894(None) 
buy86436541buy
gay76856491gay
gey75738301gey
goy77844551goy
gul45832791gul
gum67439531gum
gun47240801gun
gut46753851gut
guv74523171guv
guys85019641guys
aby810238062aby
agly86821802agly
ague55725922ague
any68440492any
auk76234142auk
ay511773892_ay
bay89661642bay
bey86645422bey
boy87753562boy
bub76343982bub
bud67041272bud
bug65340742bug
bum75342692bum
bun56348142bun
buoy95921782buoy
bur55744692bur
bury95633592bury
bus56950972bus
busy94727172busy
but55963022but
buys95726792buys
by77529232_by
cay87155982cay
coy810557552coy
cry89726242cry
cub76940942cub
cud67937452cud
cue57544182cue
cum76440162cum
cup76738242cup
cur56841982cur
cut57957662cut
day76254112day
dey77243372dey
dry76526032dry
dub66642202dub
dud56737592dud
due45249862due
dug58138692dug
duh77930382duh
dui46433382dui
duly85323032duly
dun46545582dun
duo48536142duo
dup67637882dup
duty85321452duty
eggy96611852eggy
fay97454862fay
fey95940882fey
fly97124952fly
foy96044262foy
fry96226502fry
fub86337392fub
fud76335152fud
fug76234512fug
fumy127118582fumy
fun66841142fun
fur66637322fur
fury107727972fury
gab67155992gab
gaby107123192gaby
gad57556652gad
gae46457702gae
gag57753632gag
gal46055512gal
gam67060062gam
gamy105427532gamy
gan48060132gan
gap67055612gap
gapy106320912gapy
gar47259902gar
gas48870252gas
gat46880512gat
gaud67025432gaud
gaudy106611462gaudy
gaum75726422gaum
gaun56427712gaun
gaur56723352gaur
gauzy18489212gauzy
gays87338022gays
ged57044532ged
gee45359202gee
gel45642432gel
gem66840222gem
gen45950512gen
get47467462get
geum75424552geum
ghi77019882ghi
gib66443532gib
gid57047272gid
gie47149542gie
gig56040752gig
gin46055752gin
gip67645362gip
git46266052git
gley85724652gley
glue55628492glue
gluey95715262gluey
glug66118012glug
glum75825102glum
glut56331292glut
gnu45522042gnu
gnus56518002gnus
go38748742g_o
goa47343802goa
gob68950892gob
goby106021082goby
god57449792god
goo47754772goo
gor47848262gor
gory86129662gory
gos47155132gos
got49870442got
gout56646002gout
gouty95217362gouty
gox117137182gox
goys86328412goys
gray85329892gray
grey85624042grey
grub77220082grub
grue55825712grue
grum75625082grum
guan55325582guan
guar56923292guar
guck114922532guck
gude65423332gude
guff114624932guff
guid66022822guid
gulf84929422gulf
gulfy124612002gulfy
gull54828452gull
gully94020682gully
gulp75521362gulp
gulpy114612762gulpy
guls55930852guls
gummy135413652gummy
gums75030942gums
gunk95423572gunk
gunky135514112gunky
gunny94413662gunny
guns55533482guns
guppy135211272guppy
gurry94515412gurry
guru54623912guru
gush85424002gush
gushy125213122gushy
gussy95314322gussy
gust55240702gust
gusty95119572gusty
guts56637252guts
gutsy96412842gutsy
gutty94516992gutty
guvs85816812guvs
guyed1049892guyed
guyot9314522guyot
gym95719062gym
gyp98319012gyp
hay97358772hay
hey96741062hey
hoy97447912hoy
hub86437482hub
hue66642302hue
hug76037362hug
huh96432012huh
hum85542932hum
hun65844712hun
hup86437812hup
hut66457292hut
icy86322122icy
ivy96317442ivy
jay136242672jay
joy137036362joy
jug115529542jug
jun105932062jun
jury146719592jury
jus106930222jus
jut105944012jut
kay106745542kay
key105833332key
kue76631862kue
lay68865352lay
ley66246812ley
lug46138062lug
lum55542932lum
luny77324132luny
luv67125772luv
lux106528772lux
may88757632may
mu46737482mu_
mud67336862mud
mug65837692mug
mum76643612mum
mun56143862mun
mus55946752mus
mut58357182mut
my78125652_my
nay66952772nay
nu26331952nu_
nub56439142nub
nun35537742nun
nus37939392nus
nut36651962nut
oud47439072oud
our36042892our
out38072152out
oxy136320982oxy
oy58950132_oy
pay88461182pay
ply86323552ply
pry85728052pry
pub76037692pub
pud65836652pud
pug65337182pug
pul56138062pul
pun58846512pun
puny95526992puny
pup76339882pup
pur56840552pur
pus55547842pus
put55759072put
qua124821972qua
quay164618352quay
quey164616472quey
ray66361992ray
rub56342822rub
ruby97819942ruby
rue35549262rue
rug46039152rug
ruly76323142ruly
rum56644642rum
run36244992run
rut35560522rut
say67264762say
shy96728192shy
sky106420992sky
sly66228562sly
soy67851452soy
spy86023742spy
sty66227312sty
sub55445552sub
sue35651462sue
suk75632972suk
sum56346012sum
sun37149032sun
sup57041942sup
suq126228992suq
thy97022912thy
toy69655192toy
try66529672try
tub55640032tub
tug45937402tug
tui37034022tui
tun35845192tun
tup56037542tup
tut36758092tut
tux105426572tux
ugh76520682ugh
ugly86012382ugly
uh57429852_uh
um47338832_um
un28341142_un
up47832822_up
us26937432_us
ut28647032_ut
vug76127412vug
vum85428652vum
way96757662way
why126920012why
wry96524702wry
wud76227152wud
xu96018832xu_
yay96948712yay
yuk106725602yuk
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.250714764.0
2DLD Change Limit140842870.32643202.5
3Display Results2872870.0634555.6
 (SQL Overall)1786912870.639279641.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.