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

342 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
auks8552526(None) 
arks85936871arks
asks85721211asks
auk76234141auk_
jauks165412461jauks
suks85927121suks
wauks125515161wauks
yuks116418021yuks
aahs716428562aahs
aals49941142aals
aas310975392a_as
abas68642082abas
abos67734412abos
abs59356072a_bs
abuts75417072abuts
abys97221882abys
aces67645092aces
acts66929862acts
adds67622452adds
ados57633512ados
ads49755732a_ds
agas55938842agas
ages55844592ages
ags47551662a_gs
agues64919052agues
ahis76135382ahis
ahs68644822a_hs
aids57846352aids
ails45654712ails
aims67738182aims
ains46158882ains
airs46447422airs
ais39083572a_is
aits46355532aits
alas46358122alas
albs68628572albs
ales47067102ales
alky115920342alky
alls46740922alls
alms65834922alms
alps65529242alps
als36663022a_ls
alts46639902alts
alums75720602alums
amas67746292amas
amis66445322amis
amoks11413552amoks
amps86230342amps
amucks1466002amucks
amus65529612amus
anas46649862anas
ands57833612ands
anes45255932anes
anis45746462anis
ankh111114412ankh
ankhs12116722ankhs
ankus91410682ankus
ants47243472ants
anus47131112anus
apes66047432apes
apos65433822apos
apps86319692apps
aquas142412612aquas
araks94820882araks
arbs66834732arbs
arcs67834782arcs
ares45871022ares
arfs76029962arfs
ark77044962ark_
arms66137492arms
ars37670932a_rs
arts49650262arts
arums75517832arums
as211083072a__s
ask77130702ask_
askos95011772askos
asps65622092asps
ass37844062a_ss
ates45047922ates
auld54125362auld
aunt46553652aunt
aunts55227632aunts
aura45836252aura
auras55932552auras
aures55137092aures
auris55331522auris
auto47432082auto
autos56523322autos
aves76142602aves
avos77227012avos
awes76037552awes
awls75926092awls
awns75324432awns
axes117337852axes
axis116127912axis
ayes76543512ayes
ays67050292a_ys
azuki1864802azuki
azukis1963732azukis
backs135729622backs
balks114926292balks
banks115527902banks
barks115735812barks
basks115621762basks
bauds85821042bauds
baulks12429372baulks
bubs86235502bubs
bucks134824292bucks
buds75235172buds
bugs76035912bugs
bulks115920612bulks
bums85934592bums
bunks115125082bunks
buns66243722buns
burs65847422burs
bus56950972bu_s
busk105429222busk
busks115521372busks
buss65134912buss
buts67247692buts
buys95726792buys
calks115421602calks
carks115534212carks
casks115720062casks
caulks125611862caulks
cauls75727772cauls
cubs85832382cubs
cuds76730472cuds
cues65438982cues
cuke105824982cuke
cukes115422092cukes
cups85430822cups
curs65645542curs
cusk105521632cusk
cusks114916052cusks
cuss65430612cuss
cuts65841152cuts
daks97130602daks
darks106727872darks
daubs85014562daubs
dauts67822242dauts
dawks135213492dawks
dubs78432192dubs
ducks124823212ducks
duds65530142duds
dues56045502dues
dugs614832282dugs
duke95628102duke
dukes105023472dukes
dunks105621192dunks
duns55140432duns
duos56728132duos
dups75929512dups
dusk95724152dusk
dusks105317252dusks
elks85820032elks
fauns84516752fauns
fubs96328792fubs
fucks144419252fucks
fuds86528562fuds
fugs85730692fugs
funks125318912funks
funs75235732funs
furs76735042furs
fuss76027932fuss
gauds75717722gauds
gaums86217072gaums
gaurs66317992gaurs
gauss65613452gauss
gawks136811632gawks
gucks123917302gucks
guls55930852guls
gums75030942gums
gunks104517722gunks
guns55533482guns
guts56637252guts
guvs85816812guvs
guys85019642guys
hacks144928712hacks
haiks125120932haiks
hakus125114112hakus
hanks126226862hanks
harks126333432harks
hauls86123732hauls
hawks155415702hawks
hubs96027142hubs
hucks144322172hucks
hues75235232hues
hugs86129752hugs
hulks125715482hulks
hums96831422hums
hunks125321452hunks
huns76136932huns
husk116021952husk
husks125015452husks
huts76737442huts
ilks87218572ilks
inks86926502inks
irks86220132irks
jacks185219832jacks
jauk155816092jauk_
jaups144810532jaups
jouks165612342jouks
jugs125525602jugs
juke154721662juke
jukes165319102jukes
juku154414852juku
jukus16398672jukus
junks164815972junks
jus106930222ju_s
juts115930162juts
kues86426772kues
lacks116129202lacks
larks95227812larks
lauds65618482lauds
leks85427602leks
lucks115723562lucks
lues45943552lues
lugs55233522lugs
lums65734242lums
lunks94822452lunks
lurks95218742lurks
luvs75818502luvs
macks135127602macks
marks115933482marks
masks115320532masks
mauds85519272mauds
mauls76524952mauls
mauts75927192mauts
mucks134622642mucks
muds75530652muds
mugs76232042mugs
mums85732772mums
muns65535912muns
murks114821722murks
mus55946752mu_s
musk104526192musk
musks116119642musks
muss64933762muss
muts64839982muts
narks96026032narks
neuks96510862neuks
nubs65927142nubs
nuke85920752nuke
nukes95418122nukes
nuns45228232nuns
nus37939392nu_s
nuts45032672nuts
oaks86527902oaks
ouds56430102ouds
ours47237562ours
outs45746962outs
packs135528932packs
paiks114719852paiks
parks116134462parks
pubs85029212pubs
pucks134322102pucks
puds75630512puds
pugs76332772pugs
puke105025462puke
pukes114523022pukes
puls65437562puls
punks114822682punks
puns66641482puns
pups86032232pups
purs65641042purs
pus55547842pu_s
puss64830132puss
puts65641752puts
racks115028852racks
rakus94413672rakus
ranks95225732ranks
rubs66133492rubs
rucks114422052rucks
rues46044482rues
rugs56033682rugs
rums64833472rums
runs46438072runs
rusk85823312rusk
rusks95816192rusks
ruts44541492ruts
sacks114228872sacks
sarks96632462sarks
sauls55128122sauls
souks94820522souks
subs66037122subs
sucks114523072sucks
suds56135292suds
sues46247652sues
suk75632972suk_
sulks94818462sulks
sums65837582sums
suns45841902suns
sups64834432sups
suqs134319652suqs
suss45229302suss
tacks115430132tacks
talks94322692talks
taluks10418282taluks
tanks94624732tanks
tasks94917582tasks
taus46342732tau_s
tauts56125512tauts
tsks86410662tsks
tubs65430062tubs
tucks114721122tucks
tugs56231672tugs
tuis44829642tuis
tuns45138662tuns
tups65628762tups
turks95320822turks
tusk85621632tusk
tusks94915532tusks
tuts45838452tuts
uke75727292_uke
ukes86122812_ukes
uns35936752_uns
ups55629052_ups
us26937432_u_s
uts35534372_uts
vaus75928922vau_s
vugs87022872vugs
wacks146626282wacks
walks126218502walks
wanks126124482wanks
warks127932402warks
wauk115220592wauk_
wauls86120552wauls
woks116224902woks
wuss75219332wuss
yacks144419812yacks
yaks116025202yaks
yanks125316572yanks
yauds95013222yauds
yaups105910742yaups
yeuks125110092yeuks
yoks116223742yoks
yucks144717192yucks
yuk106725602yuk_
yups96121602yups
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.0632836365.1
2DLD Change Limit298723420.85634897.2
3Display Results3423420.0804275.0
 (SQL Overall)1786913420.999178869.9
 
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.