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

315 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
tug4593740(None) 
bug65340741bug
dug58138691dug
fug76234511fug
hug76037361hug
jug115529541jug
lug46138061lug
mug65837691mug
pug65337181pug
rug46039151rug
tag47259491tag
teg45741621teg
thug86415481thug
tog410255041tog
trug55720041trug
tub55640031tub
tugs56231671tugs
tui37034021tui
tun35845191tun
tung55328161tung
tup56037541tup
tut36758091tut
tux105426571tux
vug76127411vug
ag311067462_ag
auk76234142auk
bag67059222bag
beg65944132beg
big67345712big
bog67852412bog
bub76343972bub
bud67041272bud
bugs76035912bugs
bum75342692bum
bun56348142bun
bung75730632bung
bur55744692bur
burg74930362burg
bus56950972bus
but55963022but
buy86436542buy
chug105914112chug
cig67036182cig
cog69552902cog
cub76940942cub
cud67937452cud
cue57544182cue
cum76440162cum
cup76738242cup
cur56841982cur
cut57957662cut
dag57753002dag
dig57544472dig
dog57449752dog
drug65718132drug
dub66642202dub
dud56737592dud
due45249862due
dugs614832282dugs
duh77930382duh
dui46433382dui
dun46545582dun
dung66328432dung
duo48536142duo
dup67637882dup
egg56918672egg
eng46726782eng
erg45531072erg
etui45416232etui
fag76852362fag
fig76242832fig
fog76945562fog
frug86517102frug
fub86337392fub
fud76335152fud
fugs85730692fugs
fugu85419862fugu
fun66841142fun
fur66637322fur
gag57753632gag
gig56040752gig
glug66118012glug
gul45832792gul
gum67439532gum
gun47240802gun
gut46753852gut
guv74523172guv
guy75728942guy
hag77255742hag
hog78049062hog
hub86437482hub
hue66642302hue
huge86321652huge
hugs86129752hugs
huh96432012huh
hum85542932hum
hun65844712hun
hung86126352hung
hup86437812hup
hut66457292hut
igg57116792igg
jag116542712jag
jig115633512jig
jog117438312jog
juga126417322juga
jugs125525602jugs
jun105932062jun
jus106930222jus
jut105944012jut
keg86432532keg
kue76631862kue
lag47862122lag
leg46446112leg
log46252682log
luge55531642luge
lugs55233522lugs
lum55542932lum
lung55732492lung
luv67125772luv
lux106528772lux
mag67956472mag
meg66040952meg
mig65646072mig
mog66949672mog
mu46737482mu_
mud67336862mud
mugg86316012mugg
mugs76232042mugs
mum76643612mum
mun56143852mun
mus55946752mus
mut58357182mut
nag46450812nag
neg47237342neg
nog46847312nog
nu26331952nu_
nub56439142nub
nun35537742nun
nus37939392nus
nut36651962nut
oud47439072oud
our36042892our
out38072152out
peg65843062peg
pig65744972pig
plug74915992plug
ptui64912482ptui
pub76037692pub
pud65836652pud
pugh106619232pugh
pugs76332772pugs
pul56138062pul
pun58846512pun
pung75429632pung
pup76339882pup
pur56840552pur
pus55547842pus
put55759072put
qua124821972qua
quag144815942quag
rag45761322rag
reg46146492reg
rig46748122rig
rub56342822rub
rue35549262rue
ruga56121232ruga
rugs56033682rugs
rum56644642rum
run36244982run
rung56429972rung
rut35560522rut
sag46163402sag
seg45544882seg
slug55124642slug
smug75815262smug
snug55218692snug
stag57332002stag
stub66221842stub
stud56220092stud
stum65526012stum
stun45623452stun
stung65417152stung
sub55445552sub
sue35651462sue
sugh86423442sugh
suk75632972suk
sum56346012sum
sun37149032sun
sung55832172sung
sup57041942sup
suq126228992suq
ta211662452t_a
tab57460322tab
tad47959822tad
tae38267052tae
tags55545232tags
taj106442192taj
tam58663422tam
tan37167562tan
tang56138662tang
tao38358952tao
tap57663872tap
tar37570692tar
tas38477102tas
tat37690292tat
tau36856902tau
taus46342732taus
taut47048962taut
tav66043212tav
taw610155452taw
tax109449152tax
tea37353322tea
ted46446562ted
tee38366872tee
tegg65315922tegg
tegs56031492tegs
tel35647902tel
ten35856112ten
tet39274982tet
teugh95511612teugh
tew66640152tew
the67436052the
tho67433962tho
thud85613912thud
thugs95611992thugs
thus76721472thus
thy97022912thy
ti28448292t_i
tic56343462tic
tie36557532tie
til36350262til
tin36362172tin
ting56139892ting
tip56551222tip
tis37056642tis
tit36771042tit
to218858982t_o
tod49457072tod
toe310166852toe
toga57027412toga
togs57242432togs
tom514358052tom
ton310265102ton
tong56434352tong
too38965422too
top510560682top
tor39261682tor
tot38884772tot
tough97321982tough
tour45530372tour
tout46753822tout
tow610557362tow
toy69655192toy
trig55528162trig
trog57628212trog
true46725852true
trugs65516802trugs
try66529672try
tsk75814732tsk
tuba65422362tuba
tube65828662tube
tubs65430062tubs
tuck104626572tuck
tufa75016612tufa
tuff104528522tuff
tuft76929512tuft
tuis44829642tuis
tule45735872tule
tump85927032tump
tuna45127842tuna
tune45635862tune
tungs65520622tungs
tuns45138662tuns
tups65628762tups
turd56027622turd
turf75334052turf
turk86125862turk
turn46330382turn
tush74523902tush
tusk85621632tusk
tuts45838452tuts
tutu48423172tutu
twa67721642twa
twig87615772twig
two67925832two
tye65837442tye
ugh76520682_ugh
uh57429852_uh
um47338832_um
un28341132_un
up47832822_up
us26937432_us
ut28647032_ut
uta37425582uta
ute35335882ute
uts35534372uts
veg76931062veg
vig75637522vig
vugg95612712vugg
vugh117115722vugh
vugs87022872vugs
vum85428652vum
wag76451752wag
wig76740382wig
wog76242732wog
wud76227152wud
xu96018832xu_
yag76947732yag
yuga85615422yuga
yuk106725602yuk
yum86132822yum
yup86031702yup
zag137539472zag
zig136931902zig
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.0602978183.3
2DLD Change Limit140843150.40634689.7
3Display Results3153150.0635000.0
 (SQL Overall)1786913150.529337790.2
 
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.