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

234 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
yuks11641802(None) 
auks85525261auks
suks85927121suks
yaks116025201yaks
yeuks125110091yeuks
yoks116223741yoks
yucks144717191yucks
yuk106725601yuk_
yups96121601yups
arks85936872arks
asks85721212asks
auk76234142auk_
bubs86235492bubs
bucks134824292bucks
buds75235172buds
bugs76035912bugs
bulks115920612bulks
bums85934592bums
bunks115125082bunks
buns66243722buns
burs65847422burs
bus56950972bu_s
busk105429222busk
busks115521372busks
buss65134912buss
buts67247692buts
buys95726792buys
cubs85832382cubs
cuds76730472cuds
cues65438982cues
cuke105824982cuke
cukes115422092cukes
cups85430822cups
curs65645542curs
cusk105521632cusk
cusks114916052cusks
cuss65430612cuss
cuts65841152cuts
daks97130602daks
dubs78432192dubs
ducks124823212ducks
duds65530142duds
dues56045502dues
dugs614832282dugs
duke95628102duke
dukes105023472dukes
dunks105621192dunks
duns55140432duns
duos56728132duos
dups75929512dups
dusk95724152dusk
dusks105317252dusks
elks85820032elks
fubs96328792fubs
fucks144419252fucks
fuds86528562fuds
fugs85730692fugs
funks125318912funks
funs75235732funs
furs76735042furs
fuss76027932fuss
gucks123917302gucks
guls55930852guls
gums75030942gums
gunks104517722gunks
guns55533482guns
guts56637252guts
guvs85816812guvs
guys85019642guys
hubs96027142hubs
hucks144322172hucks
hues75235232hues
hugs86129752hugs
hulks125715482hulks
hums96831422hums
hunks125321452hunks
huns76136932huns
husk116021952husk
husks125015452husks
huts76737442huts
ilks87218572ilks
inks86926502inks
irks86220132irks
jauks165412462jauks
jouks165612342jouks
jugs125525602jugs
juke154721662juke
jukes165319102jukes
juku154414852juku
jukus16398672jukus
junks164815972junks
jus106930222ju_s
juts115930162juts
kues86426772kues
kyaks11459162kyaks
leks85427602leks
lucks115723562lucks
lues45943552lues
lugs55233522lugs
lums65734242lums
lunks94822452lunks
lurks95218742lurks
luvs75818502luvs
mucks134622642mucks
muds75530652muds
mugs76232042mugs
mums85732772mums
muns65535912muns
murks114821722murks
mus55946752mu_s
musk104526192musk
musks116119642musks
muss64933762muss
muts64839982muts
neuks96510862neuks
nubs65927142nubs
nuke85920752nuke
nukes95418122nukes
nuns45228232nuns
nus37939392nu_s
nuts45032672nuts
oaks86527902oaks
ouds56430102ouds
ours47237562ours
outs45746962outs
pubs85029212pubs
pucks134322102pucks
puds75630512puds
pugs76332772pugs
puke105025462puke
pukes114523022pukes
puls65437562puls
punks114822682punks
puns66641482puns
pups86032232pups
purs65641042purs
pus55547842pu_s
puss64830132puss
puts65641752puts
rubs66133492rubs
rucks114422052rucks
rues46044482rues
rugs56033682rugs
rums64833472rums
runs46438072runs
rusk85823312rusk
rusks95816192rusks
ruts44541492ruts
souks94820522souks
subs66037122subs
sucks114523072sucks
suds56135292suds
sues46247652sues
suk75632972suk_
sulks94818462sulks
sums65837582sums
suns45841902suns
sups64834432sups
suqs134319652suqs
suss45229302suss
tsks86410662tsks
tubs65430062tubs
tucks114721122tucks
tugs56231672tugs
tuis44829642tuis
tuns45138662tuns
tups65628762tups
turks95320822turks
tusk85621632tusk
tusks94915532tusks
tuts45838452tuts
uke75727292_uke
ukes86122812_ukes
uns35936752_uns
ups55629052_ups
us26937432_u_s
uts35534372_uts
vugs87022872vugs
wauks125515162wauks
woks116224902woks
wuss75219332wuss
yacks144419812yacks
yags86632292yags
yak107038562yak_
yams95330732yams
yanks125316572yanks
yaps95933522yaps
yauds95013222yauds
yaups105910742yaups
yaws105531212yaws
yays105728912yays
yeas78638422yeas
yelks126413622yelks
yens75832262yens
yeps95924402yeps
yerks125416562yerks
yes66250612y_es
yeuk116015472yeuk_
yeuky15547032yeuky
yews105323962yews
yids85224952yids
yikes125117752yikes
yins75335122yins
yips95226692yips
yobs96028082yobs
yocks144418372yocks
yods86531182yods
yok107335242yok_
yoke115626392yoke
yokes125223022yokes
yolks125412772yolks
yours85217872yours
yous76230652yous
yows106433122yows
yuan76120012yuan
yuans84613322yuans
yuca95716722yuca
yucas106013912yucas
yuch125818532yuch
yuck136423532yuck
yucky175411692yucky
yuga85615422yuga
yugas95012062yugas
yukky14425212yukky
yule75725142yule
yules84521582yules
yum86132822yu_m
yup86031702yu_p
yurt76435042yurt
yurts87216532yurts
yutz167519882yutz
ywis105313102ywis
zeks175815062zeks
zouks184410502zouks

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.1261418182.5
2DLD Change Limit298722341.01629401.6
3Display Results2342340.0603900.0
 (SQL Overall)1786912341.202148661.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.