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

427 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
ours4723756(None) 
burs65847421burs
curs65645541curs
fours85521491fours
furs76735041furs
hours85422381hours
lours55125291lours
oars46846031oars
ors35750111o_rs
ouds56430101ouds
our36042891our_
outs45746961outs
pours74623181pours
purs65641041purs
sours55230501sours
tours55325861tours
yours85217871yours
airs46447422airs
amours83512642amours
ars37670932_ars
auks85525262auks
aura45836252aura
auras55932552auras
aures55137092aures
auris55331522auris
bars66564092bars
blurs74619082blurs
boars75229602boars
boors74325012boors
bourg84113842bourg
bourgs9459992bourgs
bourn75518482bourn
bourns84114062bourns
bourse84414332bourse
bouts75131312bouts
bubs86235492bubs
buds75235172buds
bugs76035912bugs
buhrs104811242buhrs
bums85934592bums
buns66243722buns
bur55744692bur_
bura66139532bura
buras74736292buras
burb85334672burb
burbs95423492burbs
burd75534262burd
burds84626062burds
burg74930362burg
burgs84924092burgs
burl64937182burl
burls74228852burls
burn65636422burn
burns74926772burns
burp85028882burp
burps94220172burps
burr65631232burr
burrs74925652burrs
bursa74921522bursa
burse75527252burse
burst75332242burst
bury95633592bury
bus56950972bu_s
buss65134912buss
buts67247692buts
buys95726792buys
cars67364762cars
clours85215082clours
coirs75221052coirs
cors66656442cors
coups95522472coups
course85117772course
court75532762court
courts84216162courts
crus65828482crus
cubs85832382cubs
cuds76730472cuds
cues65438982cues
cups85430822cups
cur56841982cur_
curb86732222curb
curbs94821652curbs
curd77634982curd
curds85725612curds
cure66149122cure
cures75645432cures
curf97538782curf
curfs105122142curfs
curl66035052curl
curls74927102curls
curn66731882curn
curns74924272curns
curr65429652curr
currs75624392currs
curse75829142curse
curst74931022curst
curt67051712curt
cuss65430612cuss
cuts65841152cuts
doers65225712doers
doors65022132doors
dorrs65520592dorrs
dors56747602dors
doums85417642doums
dour56330432dour_
doura66518662doura
douras75016722douras
dubs78432192dubs
duds65530142duds
dues56045502dues
dugs614832282dugs
duns55140432duns
duos56728132duos
dups75929512dups
dura55232112dura
duras65727722duras
dure56341812dure
dures65635922dures
durn56127622durn
durns64819862durns
duro56228022duro
duros65422692duros
durr55624352durr
durrs65519992durrs
durst66125172durst
ears46356592ears
errs45622532errs
ers36046282_ers
euro45325272euro
euros54920242euros
firs76637712firs
flours94414052flours
fouls87221432fouls
four76226862four_
fubs96328792fubs
fuds86528562fuds
fugs85730692fugs
funs75235732funs
fur66637322fur_
furl77030882furl
furls85322052furls
fury107727972fury
fuss76027932fuss
gars55750742gars
gaurs66317992gaurs
goers65520252goers
gourd71011902gourd
gourds8108252gourds
gouts64826172gouts
guars65021042guars
guls55930852guls
gums75030942gums
guns55533482guns
gursh94512332gursh
guru54623912guru
gurus64318192gurus
guts56637252guts
guvs85816812guvs
guys85019642guys
hers75844872hers
hoars85925542hoars
hoers85724922hoers
hour75827312hour_
houri85915232houri
houris94514562houris
hubs96027142hubs
hues75235232hues
hugs86129752hugs
hums96831422hums
huns76136932huns
hurds95219072hurds
hurl76029932hurl
hurls86522712hurls
hurst85527192hurst
hurt77142572hurt
hurts86922822hurts
huts76737442huts
jars117338352jars
jouks165612342jouks
jugs125525602jugs
jura116024892jura
jury146719592jury
jus106930222ju_s
juts115930162juts
kirs85831732kirs
knurs94511152knurs
kors85933012kors
kouros1039182kouros
kues86426772kues
kuru85521802kuru
kurus98015632kurus
lars46956572lars
louis57322322louis
loups75319622loups
lour45430682lour_
loury85716752loury
louts56330272louts
lues45943552lues
lugs55233522lugs
lums65734242lums
lure45142462lure
lures56138532lures
lurk86624162lurk
lurks95218742lurks
luvs75818502luvs
mars66261862mars
mirs66940562mirs
mohurs1135932mohurs
moors74923142moors
mors65950062mors
moues75732842moues
mourn77215012mourn
mourns84111012mourns
muds75530652muds
mugs76232042mugs
mums85732772mums
muns65535912muns
mura65633292mura
muras75329562muras
mure65941332mure
mures75937212mures
murk105527252murk
murks114821722murks
murr65225132murr
murrs75521292murrs
mus55946752mu_s
muss64933762muss
muts64839982muts
noirs55615462noirs
nouns56717312nouns
nous46136982nou_s
nubs65927142nubs
nuns45228232nuns
nurd56224342nurd
nurds65518522nurds
nurl45327242nurl
nurls55519682nurls
nurse54420122nurse
nus37939392nu_s
nuts45032672nuts
oafs76425262oafs
oaks86527902oaks
oar37057952oar_
oats46554212oats
obas65730932obas
obes66036832obes
obis66226832obis
ocas66729632ocas
occurs10136552occurs
odas57230262odas
odds68919922odds
odes57243242odes
odors64514272odors
odours7418232odours
ods47546212o_ds
oes35866192o_es
offs107117012offs
ogre56320742ogre
ogres65818632ogres
ohms95514032ohms
ohs66232312o_hs
oils46337972oils
okas85225392okas
okes84936342okes
okra86413572okra
okras94410972okras
olds55926572olds
oles46453472oles
omers76923192omers
oms56337512o_ms
ones46146532ones
onos46229002onos
ons36148512o_ns
onus45826812onus
oohs75220692oohs
oops65232672oops
oots46446442oots
opes65942612opes
ops56641252o_ps
opts68124742opts
opus66420592opus
or27354732o_r_
ora37250832o_ra
orb55736862o_rb
orbs66626252orbs
orc57034922o_rc
orcs67025432orcs
ore36661832o_re
ores46056682ores
orra46120722orra
orris54516552orris
ort39465232o_rt
orts46538332orts
os211359882o__s
oses46641512oses
ouch95724632ouch
oud47439072ou_d
ouph95618372ouph
ouphs104311272ouphs
ourie54027292ourie
oust46747442oust
ousts55225702ousts
out38072152ou_t
outers64230162outers
outre53922192outre
ouzo133516932ouzo
ouzos143210412ouzos
overs85224792overs
owes75137102owes
owls76022932owls
owns76819582owns
oxes116530722oxes
oyers87620882oyers
oyes74940132oyes
pars67560792pars
poufs105616062poufs
pour611527472pour_
pouts75530322pouts
pubs85029212pubs
puds75630512puds
pugs76332772pugs
puls65437562puls
puns66641482puns
pups86032232pups
pur56840552pur_
pure65543332pure
puri65931442puri
puris75332022puris
purl65631422purl
purls74723352purls
purr64925812purr
purrs75320432purrs
purse76028892purse
pursy105016412pursy
pus55547842pu_s
puss64830132puss
puts65641752puts
qursh174110842qursh
roars55622232roars
roues56039352roues
roups75118902roups
routs57133412routs
rubs66133492rubs
ruers515019412ruers
rues46044482rues
rugs56033682rugs
rums64833472rums
runs46438072runs
ruts44541492ruts
scours84913582scours
sers45746652sers
sirs44338332sirs
slurs54123372slurs
soars54732512soars
sorus54527582sorus
souks94820522souks
souls55127362souls
soups75322942soups
sour45935892sour_
sous46947212sou_s
spurs74621522spurs
stours65015622stours
subs66037122subs
suds56135292suds
suers55128482suers
sues46247652sues
suks85927122suks
sums65837582sums
suns45841902suns
sups64834432sups
suqs134319652suqs
sura45740292sura
suras55336322suras
surd56433812surd
surds65624662surds
sure45447412sure
surf76039312surf
surfs85022542surfs
suss45229302suss
tars46763952tars
torrs53923562torrs
tors46157382tors
torus54329762torus
tour45530372tour_
touts54830392touts
tubs65430062tubs
tugs56231672tugs
tuis44829642tuis
tuns45138662tuns
tups65628762tups
turd56027622turd
turds65021692turds
turf75334052turf
turfs84620442turfs
turk86125862turk
turks95320822turks
turn46330382turn
turns55623232turns
turps74918732turps
tuts45838452tuts
uns35936752_uns
ups55629052_ups
urb55731102_urb
urbs65922052_urbs
urd46427042_urd
urds55922422_urds
urn35731462_urn
urns46323892_urns
urp56426392_urp
urps66920472_urps
ursa44116902_ursa
urus46426132_urus
us26937432_u_s
uts35534372_uts
vars75742072vars
vugs87022872vugs
wars78659802wars
wurst85122992wurst
wuss75219332wuss
your78623432your_
yourn87512772yourn
yous76230652you_s
yuks116418022yuks
yups96121602yups
yurt76435042yurt
yurts87216532yurts
zouks184410502zouks

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.0762351197.4
2DLD Change Limit298724270.95331345.2
3Display Results4274270.0934591.4
 (SQL Overall)1786914271.122159261.1
 
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.