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

253 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
tux10542657(None) 
lux106528771lux
tax109449151tax
tub55640031tub
tug45937401tug
tui37034021tui
tun35845191tun
tup56037541tup
tut36758091tut
auk76234142auk
ax911057782_ax
box1210142342box
brux136315272brux
bub76343982bub
bud67041272bud
bug65340742bug
bum75342692bum
bun56348142bun
bur55744692bur
bus56950972bus
but55963022but
buy86436542buy
cox1210346782cox
crux135415002crux
cub76940942cub
cud67937452cud
cue57544182cue
cum76440162cum
cup76738242cup
cur56841982cur
cut57957662cut
dex116936882dex
doux125817982doux
dub66642202dub
dud56737592dud
due45249862due
dug58138692dug
duh77930382duh
dui46433382dui
dun46545582dun
duo48536142duo
dup67637882dup
eaux116618422eaux
etui45416232etui
ex98835642_ex
faux146519072faux
fax138143312fax
fix136236102fix
flux145617742flux
fox136737862fox
fub86337392fub
fud76335152fud
fug76234512fug
fun66841142fun
fur66637322fur
gox117137182gox
gul45832792gul
gum67439532gum
gun47240802gun
gut46753852gut
guv74523172guv
guy75728942guy
hex137436172hex
hub86437482hub
hue66642302hue
hug76037362hug
huh96432012huh
hum85542932hum
hun65844712hun
hup86437812hup
hut66457292hut
jeux184311272jeux
jug115529542jug
jun105932062jun
jus106930222jus
jut105944012jut
kex146029582kex
kue76631862kue
lax107651522lax
lex107943822lex
lox108240962lox
lug46138062lug
lum55542932lum
luv67125772luv
luxe115222692luxe
max129045452max
mix126138182mix
mu46737482mu_
mud67336862mud
mug65837692mug
mum76643612mum
mun56143862mun
mus55946752mus
mut58357182mut
nix106932832nix
nu26331952nu_
nub56439142nub
nun35537742nun
nus37939392nus
nut36651962nut
oud47439072oud
our36042892our
out38072152out
ox98242382_ox
pax127346852pax
pix126437932pix
pox126140692pox
ptui64912482ptui
pub76037692pub
pud65836652pud
pug65337182pug
pul56138062pul
pun58846512pun
pup76339882pup
pur56840552pur
pus55547842pus
put55759072put
pyx157817012pyx
qua124821972qua
rax108445722rax
rex105740992rex
roux117419362roux
rub56342822rub
rue35549262rue
rug46039152rug
rum56644642rum
run36244982run
rut35560522rut
sax107447642sax
sex107043222sex
six105339742six
sox106444192sox
stub66221842stub
stud56220092stud
stum65526022stum
stun45623452stun
sub55445552sub
sue35651462sue
suk75632972suk
sum56346012sum
sun37149032sun
sup57041942sup
suq126228992suq
ta211662452t_a
tab57460322tab
tad47959822tad
tae38267052tae
tag47259492tag
taj106442192taj
tam58663422tam
tan37167572tan
tao38358952tao
tap57663872tap
tar37570692tar
tas38477102tas
tat37690292tat
tau36856902tau
taus46342732taus
taut47048962taut
tav66043212tav
taw610155452taw
taxa116820092taxa
taxi117124762taxi
tea37353322tea
ted46446562ted
tee38366872tee
teg45741622teg
tel35647902tel
ten35856112ten
tet39274992tet
tew66640152tew
text116033932text
the67436052the
tho67433962tho
thud85613912thud
thug86415482thug
thus76721472thus
thy97022912thy
ti28448292t_i
tic56343462tic
tie36557532tie
til36350262til
tin36362172tin
tip56551222tip
tis37056642tis
tit36771052tit
to218858982t_o
tod49457072tod
toe310166852toe
tog410255042tog
tom514358052tom
ton310265102ton
too38965422too
top510560682top
tor39261682tor
tot38884772tot
tour45530382tour
tout46753822tout
tow610557362tow
toy69655192toy
true46725852true
trug55720042trug
try66529672try
tsk75814732tsk
tuba65422362tuba
tube65828662tube
tubs65430062tubs
tuck104626572tuck
tufa75016612tufa
tuff104528522tuff
tuft76929512tuft
tugs56231672tugs
tuis44829642tuis
tule45735872tule
tump85927032tump
tuna45127842tuna
tune45635862tune
tung55328162tung
tuns45138662tuns
tups65628762tups
turd56027622turd
turf75334052turf
turk86125862turk
turn46330382turn
tush74523902tush
tusk85621632tusk
tuts45838452tuts
tutu48423172tutu
tuxes124316042tuxes
twa67721642twa
two67925832two
tye65837442tye
uh57429852_uh
um47338832_um
un28341132_un
up47832822_up
us26937432_us
ut28647032_ut
uta37425582uta
ute35335882ute
uts35534372uts
vex136429172vex
vox136628152vox
vug76127412vug
vum85428652vum
wax137041182wax
wud76227152wud
xu96018832xu_
yuk106725602yuk
yum86132822yum
yup86031702yup
zax197630632zax
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.0802233637.5
2DLD Change Limit140842530.39036112.8
3Display Results2532530.0465500.0
 (SQL Overall)1786912530.516346300.4
 
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.