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

216 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
upas6832238(None) 
pas58775741_pas
pupas95219281pupas
spas67036721spas
ups55629051up_s
utas45924951utas
aas310975392_aas
abas68642082abas
agas55938842agas
alas46358122alas
amas67746292amas
anas46649862anas
apes66047432apes
apos65433822apos
apps86319692apps
as211083072__as
auras55932552auras
baas66844672baas
baps86040842baps
bas58681752_bas
bias64738152bias
boas66150832boas
bras65746452bras
bunas75126572bunas
buras74736292buras
caps87147892caps
cuppas12458592cuppas
cups85430822cup_s
daps77239162daps
dopas85019062dopas
dumas85420432dumas
dupes86425932dupes
dups75929512dup_s
duras65727722duras
ephas10311542ephas
epos66723732epos
eras45441502eras
etas46432272etas
eyas76427432eyas
fas68262932_fas
gaps76042972gaps
gas48870252_gas
goas55239942goas
haps96443462haps
has67372652_has
hulas84920882hulas
jubas144614222jubas
judas134911882judas
jupes145218552jupes
kaas86531842kaas
kapas116021732kapas
kas77058582_kas
keas86337092keas
koas85635092koas
kvas117015942kvas
laps66848872laps
las37281472_las
leas45954182leas
lumas75622912lumas
lunas55025012lunas
lupus74512522lupus
maps86141042maps
mas58175812_mas
moas65545342moas
muras75329562muras
napas75924352napas
naps66238582naps
nipas77116672nipas
obas65730932obas
ocas66729632ocas
odas57230262odas
okas85225392okas
opah96218402opah
opahs105411982opahs
opal66923522opal
opals75718352opals
opes65942612opes
ops56641252op_s
opts68124742opts
opus66420592opus
ouphs104311272ouphs
pa410456482_pa_
pac79054082_pac
pacs85842182_pacs
pad68057322_pad
pads76742952_pads
pah88853592_pah
pal56761672_pal
pals66951352_pals
pam77858392_pam
pams85641762_pams
pan58466442_pan
pans65855722_pans
pap76758402_pap
papas94927492papas
paps86443452_paps
par57467022_par
pars67560792_pars
pase65346862_pase
pash95638132_pash
pass65239952_pass
past65959012_past
pat58089462_pat
pats66460852_pats
paw87651172_paw
paws96038182_paws
pax127346852_pax
pay88461182_pay
pays95940222_pays
peas65755062peas
pes57259782_pes
pias66542552pias
pis56362032_pis
pubs85029212pubs
puds75630512puds
pugs76332772pugs
pujas145513322pujas
puls65437562puls
pumas95121562pumas
punas74826752punas
puns66641482puns
pupa85422812pupa_
pupae96515642pupae
pupal97616872pupal
pups86032232pups
pupus94614042pupus
purs65641042purs
pus55547842_pus
puss64830132puss
puts65641752puts
pyas96225702pyas
raps66247732raps
ras37575392_ras
rias45540592rias
ryas77224612ryas
saps65346372saps
seas45755272seas
skas85325712skas
spa55730812spa_
spae65034322spae
spaes76029972spaes
spam85930042spam
spams94922192spams
span65234662span
spans74528732spans
spar65433302spar
spars75431542spars
spasm94514172spasm
spat66548522spat
spats75031382spats
spay96631662spay
spays105520512spays
spaz155626162spaz
stupas83910882stupas
subas74724072subas
supes75628302supes
sups64834432sup_s
suras55336322suras
tapas74627712tapas
taps66050672taps
tas38477102_tas
teas45851492teas
tepas76521682tepas
tubas75119572tubas
tufas85314382tufas
tunas54224122tunas
tups65628762tup_s
twas76824082twas
udos56619902udos
ughs85410972ughs
ukase9428492ukase
ukes86122812ukes
ulan46527392ulan
ulans54921302ulans
ulnas55716532ulnas
ulpan7310122ulpan
ulus45622562ulus
ulvas84511502ulvas
umps85721942umps
unai44824782unai
unais53420772unais
unau43924152unau
unaus53216572unaus
uns35936752u_ns
up47832822up__
upases84112902upases
upby1139062upby
upcast102710092upcast
updo76712882updo
updos8389512updos
upo58925862up_o
upon65817582upon
urase54624682urase
urbs65922052urbs
urds55922422urds
ureas55826012ureas
urns46323892urns
urps66920472urps
ursa44116902ursa
urus46426132urus
us26937432u__s
uses44931112uses
uta37425582uta_
utes45930882utes
uts35534372u_ts
uveas84912282uveas
vas67755772_vas
waps96642082waps
was68767562_was
yaps95933522yaps
yeas78638422yeas
yucas106013912yucas
yugas95012062yugas
yups96121602yup_s
zaps156826892zaps
zas126946832_zas

Search took 4 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.1431249587.4
2DLD Change Limit298722161.93615429.8
3Display Results2162160.0932322.6
 (SQL Overall)1786912162.17282270.3
 
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.