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

242 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
uta3742558(None) 
eta35834191eta
ta211662451_ta
ut28647031ut_
utas45924951utas
ute35335881ute
uts35534371uts
aa219179952_aa
aba512850952aba
acta69524802acta
aga410447232aga
aha611246642aha
ala312463602ala
ama510853302ama
ana39559832ana
anta46839582anta
at212393402at_
atap66722452atap
ate37059242ate
atma68121772atma
att35454652att
aura45836252aura
auto47432082auto
ava610139322ava
awa611939672awa
ba49962342_ba
baa510650422baa
bat510988952bat
beta66234132beta
boa56954032boa
bota66236502bota
bra56339462bra
buna64730722buna
bura66139532bura
but55963022but_
bute66739672bute
buts67247692buts
butt65143742butt
cat58282342cat
cut57957662cut_
cute66440452cute
cuts65841152cuts
data56026652data
dita56032522dita
duma75524452duma
dura55232112dura
duty85321452duty
eat36989052eat
era35741502era
et26964192et_
etas46432272etas
eth66630982eth
etna46415262etna
fa510148452_fa
fat68178082fat
feta76528902feta
futz167823802futz
gat46880512gat
geta56627442geta
goa47343802goa
gut46753852gut_
guts56637252guts
gutta64613382gutta
ha510259942_ha
hat67289962hat
hula74923752hula
hut66457292hut_
huts76737442huts
iota45127832iota
it28455682it_
its35538832its
jota116423622jota
juba134916982juba
juga126417322juga
junta123713672junta
jura116024892jura
jut105944012jut_
jute115327892jute
juts115930162juts
ka69145082_ka
kat77468292kat
kata85626022kata
kea76540912kea
koa76737772koa
kuna85120702kuna
kurta95113912kurta
la219261632_la
lat37593402lat
lea37660182lea
lota47233502lota
luma65527522luma
luna46229852luna
lute46341012lute
lutea54819072lutea
lutz136826322lutz
ma410060662_ma
mat58083942mat
meta65932412meta
moa57249182moa
mura65633302mura
mut58357182mut_
mute65136872mute
muts64839982muts
mutt65739402mutt
na28652482_na
nota46830772nota
nth66320592nth
nut36651962nut_
nuts45032672nuts
oat39888262oat
oba57531552oba
oca56731732oca
oda48133042oda
oka76926802oka
ora37250832ora
out38072152out_
outs45746962outs
ova66823792ova
pa410456482_pa
pat58089462pat
pea56657242pea
pia56848032pia
pita65436432pita
pruta7314242pruta
puja135714922puja
pula65129372pula
puma85424122puma
puna65331652puna
pupa85422812pupa
put55759072put_
puts65641752puts
putt66937842putt
putz158326322putz
pya87023752pya
qat125253332qat
qua124821972qua
quota145111962quota
rat37892742rat
ria36745502ria
rota45834342rota
ruga56121232ruga
rut35560522rut_
ruth76825992ruth
ruts44541492ruts
rya67622012rya
sat36288482sat
scuta75815752scuta
sea36161292sea
seta45637312seta
sha69837782sha
ska76925862ska
spa55730812spa
sputa74612962sputa
stab67329932stab
stag57332002stag
star48037762star
stat47352692stat
staw78627692staw
stay78333722stay
stoa45425912stoa
sty66227312sty
suba64926602suba
sura45740292sura
sutra54217932sutra
sutta54015332sutta
tab57460322_tab
tad47959822_tad
tae38267052_tae
tag47259492_tag
taj106442192_taj
tam58663422_tam
tan37167572_tan
tao38358952_tao
tap57663872_tap
tar37570692_tar
tas38477102_tas
tat37690292_tat
tau36856902_tau
tav66043212_tav
taw610155452_taw
tax109449152_tax
tea37353322tea
ti28448292_ti
to218858982_to
tub55640032tub
tuba65422362tuba
tufa75016612tufa
tug45937402tug
tui37034022tui
tun35845192tun
tuna45127842tuna
tup56037542tup
tut36758092tut
tuts45838452tuts
tutu48423172tutu
tux105426572tux
twa67721642twa
udo49027302udo
ugh76520682ugh
uh57429852u_h
uke75727292uke
ulan46527392ulan
ulna46317332ulna
ultra539362ultra
ulu36028702ulu
ulva75412692ulva
um47338832u_m
umm711921262umm
ump76130442ump
un28341142u_n
unai44824782unai
unau43924152unau
uns35936762uns
unto45824282unto
up47832822u_p
upas68322382upas
upo58925862upo
ups55629052ups
urb55731112urb
urd46427052urd
urea46528062urea
urn35731472urn
urp56426402urp
ursa44116912ursa
us26937432u_s
use36835162use
utes45930882utes
uvea74712652uvea
vat67863452vat
via65636242via
vita75828522vita
wat67378922wat
wha96422072wha
ya510251502_ya
yea66445752yea
yuca95716722yuca
yuga85615422yuga
yurta86014252yurta
yutz167519882yutz
za1114939202_za
zeta135121642zeta
zoa128529992zoa

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.266671770.7
2DLD Change Limit140842420.42033533.3
3Display Results2422420.0465260.9
 (SQL Overall)1786912420.732244113.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.