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

255 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
opts6812474(None) 
oats46554211oats
oots46446441oots
opes65942611opes
ops56641251op_s
opt57545541opt_
opus66420591opus
orts46538331orts
outs45746961outs
pots66452361pots
acts66929862acts
adopts998082adopts
aits46355532aits
alts46639902alts
ants47243472ants
apes66047432apes
apos65433822apos
apps86319692apps
apt57352542apt_
arts49650262arts
bats66962332bats
bets67051442bets
bits66148162bits
boats75635152boats
bolts76232112bolts
boots75837972boots
bops86037982bop_s
borts76735452borts
bots66453952bots
botts75224862botts
bouts75131312bouts
buts67247692buts
cats66356342cats
coapts104614012coapts
coats75635002coats
colts76633292colts
compts125216652compts
coopts105814582coopts
coots75636842coots
copes97747102copes
cops86751372cop_s
costs77231142costs
cots68054842cots
cuts65841152cuts
dits56450522dits
doats65224882doats
doits66223672doits
dolts65626312dolts
dopas85019062dopas
dopes84935042dopes
dots55647662dots
eats47054872eats
efts76519482efts
epos66723732epos
fats76252502fats
fets75345942fets
fits76043462fits
fonts86124752fonts
foots85528282foots
fops96532682fop_s
forts86034452forts
gats56753442gats
gets55442482gets
gits55744592gits
goats65527302goats
gouts64826172gouts
guts56637252guts
hats76858252hats
hets75547202hets
hits75545132hits
holts85627912holts
hoots84830242hoots
hopes105835642hopes
hops97942632hop_s
hosts85526702hosts
hots78349322hots
huts76737442huts
its35538832_its
jets115834102jets
jolts125018882jolts
jots116336142jots
juts115930162juts
kats85944332kats
kits86441762kits
kophs145010932kophs
kops107031292kop_s
lats45962702lats
lets47147942lets
lits46252492lits
lofts85518362lofts
loots55431422loots
lopes76437342lopes
lops66043352lop_s
lots47652092lots
louts56330272louts
mats65460282mats
moats75827642moats
molts76032092molts
moots75831662moots
mopes95134982mopes
mops85940132mop_s
morts75533562morts
mosts76028542mosts
mots66853162mots
motts76527002motts
muts64839982muts
nets45941532nets
nits45741642nits
nowts86915862nowts
nuts45032672nuts
oafs76425262oafs
oaks86527902oaks
oars46846032oars
oast47156322oast
oasts56529182oasts
oat39888262oat_
oath76132152oath
oaths86117312oaths
obas65730932obas
obes66036832obes
obis66226842obis
obits74617552obits
ocas66729632ocas
odas57230262odas
odds68919922odds
odes57243242odes
ods47546212o_ds
oes35866192o_es
offs107117012offs
oft67744062oft_
ohms95514032ohms
ohs66232312o_hs
oils46337972oils
okas85225392okas
okes84936342okes
olds55926572olds
oles46453472oles
omits75018262omits
oms56337512o_ms
ones46146532ones
onos46229002onos
ons36148512o_ns
onto46127662onto
onus45826812onus
oohs75220692oohs
oops65232672oops
oot311274692oot_
op45850162op__
opah96218402opah
opahs105411982opahs
opal66923522opal
opals75718352opals
ope56845242op_e
oped76230152oped
open66427002open
opens76118552opens
opted84914272opted
optic93715182optic
optics102810182optics
orbs66626252orbs
orcs67025432orcs
ores46056682ores
ors35750112o_rs
ort39465232ort_
os211359882o__s
oses46641512oses
otto45220642otto
ottos54714322ottos
ouds56430102ouds
ouphs104311272ouphs
ours47237562ours
oust46747442oust
ousts55225702ousts
out38072152out_
owes75137102owes
owls76022932owls
owns76819582owns
oxes116530722oxes
oyes74940132oyes
pas58775742_pas
pats66460852pats
pes57259782_pes
pets66248332pets
pis56362032_pis
pits66348742pits
pods76540152pods
poets76024442poets
pois66539042pois
pols66044562pols
poms87037742poms
pons65850602pons
poos65949112poos
popes95933812popes
pops86340952pops
ports75934592ports
post67953362post
posts75228782posts
pot58078432pot_
potsy105815612potsy
pouts75530322pouts
pows95537662pows
pst57932512_pst
pus55547842_pus
puts65641752puts
qats135331342qats
qophs19507812qophs
rats46260372rats
rets45352562rets
roots55933672roots
ropes75940062ropes
rots46454092rots
routs57133412routs
ruts44541492ruts
septs75420602septs
sets45549502sets
sits45050202sits
softs85019232softs
soots55536202soots
sophs104916022sophs
sops65244562sop_s
sorts54536662sorts
sots45552442sots
spas67036722spas
spats75031382spats
spits74429552spits
spots74424102spots
tats46858132tats
tets45847452tets
tits46145032tits
tofts84919242tofts
toits55327472toits
toots55331872toots
topes76941762topes
tophs105220052tophs
topis76025832topis
topos75726392topos
tops66248122top_s
torts56138122torts
tots46654122tots
touts54830392touts
tuts45838452tuts
upas68322382upas
ups55629052up_s
uts35534372_uts
vats76841742vats
vets76835092vets
volts85421292volts
wats77555882wats
wets75940292wets
wits76044872wits
wonts87621542wonts
wops96634152wop_s
worts88631182worts
wots76342892wots
zits136030292zits

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 Limit298722550.93631914.5
3Display Results2552550.0634047.6
 (SQL Overall)1786912551.062168258.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.