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

340 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
oohs7522069(None) 
ohs66232311_ohs
ooh67637091ooh_
oops65232671oops
oots46446441oots
poohs103915711poohs
aahs716428562aahs
ahs68644822_ahs
boas66150832boas
bobs86340652bobs
bods76244712bods
bogs75742752bogs
boho96923322boho
bohos105618252bohos
boobs96221992boobs
books115729712books
booms95427122booms
boons75031912boons
boors74325012boors
boos67955032boos
booths115313792booths
boots75837972boots
bops86037982bops
bos57966812bo_s
bosh96328972bosh
boss65938342boss
bots66453952bots
bows96242862bows
boys96737332boys
cobs87043142cobs
cods76848102cods
cogs77340032cogs
coho97524492coho
cohos105921852cohos
cols66553082cols
cons66057692cons
coofs105924712coofs
cooks115429142cooks
cools75632632cools
coons76737282coons
coops96229642coops
coos67456492coos
coots75636842coots
cops86751372cops
cors66656442cors
cos510270392co_s
cosh96127622cosh
coss66143492coss
cots68054842cots
cows97046642cows
coys97537242coys
dahs88231812dahs
docs75631152docs
does56554472does
dogs66440152dogs
dols56943052dols
doms76239572doms
dons56048702dons
dooms85321342dooms
doors65022132doors
dors56747602dors
dos48062312do_s
doss56235042doss
dots55647662dots
dows85941052dows
edhs86212102edhs
eons46638712eons
eths76619522eths
fehs106522382fehs
fobs96034272fobs
foes76543442foes
fogs87035002fogs
foh98135892foh_
fohn106116552fohn
fohns117310782fohns
fons76943892fons
foods95924162foods
fools86824202fools
foots85528282foots
fops96532682fops
foss76431642foss
foys105628292foys
goas55239942goas
gobs76935572gobs
gods65438042gods
goes55644092goes
goods75124482goods
goofs94821002goofs
gooks105422882gooks
goons65326772goons
goops86620962goops
goos57644912goos
gos47155132go_s
gosh86123422gosh
goths96513002goths
goys86328412goys
hahs108333362hahs
hehs106723962hehs
hobs97038982hobs
hods87239862hods
hoes75755732hoes
hogs87139662hogs
hols76946292hols
hons77350782hons
hoods95124082hoods
hoofs115721042hoofs
hooks125027122hooks
hoops105621072hoops
hoots84830242hoots
hops97942632hops
hos68364192ho_s
hots78349322hots
hows106345602hows
hoys107733932hoys
ichs96214712ichs
ions46737852ions
jobs136529432jobs
joes116635892joes
jogs127129332jogs
john145512902john
johns15398712johns
josh145117612josh
joss115925592joss
jots116336142jots
jows146632092jows
joys146624662joys
koas85635092koas
kobs105831082kobs
kohl113911712kohl
kohls12437802kohls
kois85129392kois
kooks85217262kooks
kophs145010932kophs
kops107031292kops
kors85933012kors
kos76944822ko_s
koss85224812koss
lobs66441082lobs
lochs106715512lochs
logs57343112logs
loofs85623782loofs
looks95124862looks
looms75124642looms
loons55731722loons
loops75723962loops
loos49051122loos
loots55431422loots
lops66043352lops
loss45337962loss
lots47652092lots
lows75843012lows
mhos95517772mhos
moas65545342moas
mobs85737372mobs
mocs85834902mocs
mods77945052mods
mogs75439332mogs
mols65948572mols
moms86539482moms
mons68152252mons
moods85224622moods
mools76027172mools
moons75331002moons
moors74923142moors
moos66051302moos
moots75831662moots
mops85940132mops
mors65950062mors
mos57067122mo_s
mosh95227602mosh
moss67641032moss
moths106021552moths
mots66853162mots
mows96340832mows
nobs66436902nobs
nods55838222nods
noes45845392noes
nogs56534612nogs
noh66640642noh_
noms65636402noms
nooks95420392nooks
noons54125282noons
nos38859322no_s
nosh76223542nosh
nous46136982nous
nows75738232nows
oafs76425262oafs
oaks86527902oaks
oars46846032oars
oaths86117312oaths
oats46554212oats
obas65730932obas
obes66036832obes
obis66226842obis
oboes75717712oboes
obols73715862obols
ocas66729632ocas
odahs95610082odahs
odas57230262odas
odds68919922odds
odes57243242odes
odors64514282odors
ods47546212_ods
oes35866192_oes
offs107117012offs
oh57447002_oh_
ohm86523012_ohm
ohms95514032ohms
oho66534382_oho
oils46337972oils
okas85225392okas
okehs12477462okehs
okes84936342okes
olds55926572olds
oles46453472oles
oms56337512_oms
ones46146532ones
onos46229002onos
ons36148512_ons
onus45826812onus
oohed94214212oohed
oomphs1344722oomphs
oot311274692oo_t
ooze136420602ooze
oozes145418712oozes
oozy167018132oozy
opahs105411982opahs
opes65942612opes
ops56641252_ops
opts68124742opts
opus66420592opus
orbs66626252orbs
orcs67025432orcs
ores46056682ores
ors35750112_ors
orts46538332orts
os211359882_o_s
oses46641512oses
ouds56430102ouds
ouphs104311272ouphs
ours47237562ours
outs45746962outs
owes75137102owes
owls76022932owls
owns76819582owns
oxes116530722oxes
oyes74940132oyes
pehs95625762pehs
pods76540152pods
poh86740532poh_
pois66539042pois
pols66044562pols
poms87037742poms
pons65850602pons
poods85124752poods
poofs105222792poofs
pooh96027382pooh_
pools74427702pools
poons75430972poons
poops94422412poops
poos65949112poos
pops86340952pops
posh95427322posh
pots66452362pots
pows95537662pows
qophs19507812qophs
rhos76319062rhos
robs65837872robs
rocs65533662rocs
rods56442062rods
roes45954132roes
roms67038962roms
roods65125282roods
roofs85321152roofs
rooks95325042rooks
rooms75324682rooms
roots55933672roots
rots46454092rots
rows75941752rows
sobs64941752sobs
sods54940212sods
sols45448162sols
soms66239372soms
sons46049552sons
sooks94425452sooks
sooths95715582sooths
soots55536202soots
sophs104916022sophs
sops65244562sops
sos37761602so_s
soths86218622soths
sots45552442sots
sous46947212sous
sows75342492sows
soys75233932soys
tods56141842tods
toes46956442toes
togs57242432togs
toms68343492toms
tons46553052tons
tools55325242tools
toons55027532toons
tooths96013802tooths
toots55331872toots
tophs105220052tophs
tops66248122tops
tors46157382tors
tosh74826812tosh
toss45637972toss
tots46654122tots
tows78545552tows
toys78036342toys
ughs85410972ughs
voes75432822voes
vows106626942vows
woes76440662woes
wogs86531402wogs
woks116224902woks
wons74942042wons
woods95723032woods
woofs114918002woofs
wools84421462wools
woops104917522woops
woos76238802woos
woosh113710732woosh
wops96634152wops
wos66953532wo_s
wots76342892wots
wows104633492wows
yobs96028082yobs
yodhs12669012yodhs
yods86531182yods
yoghs125410592yoghs
yoks116223742yoks
yous76230652yous
yows106433122yows
zooks184716942zooks
zooms164415522zooms
zoons144919692zoons
zoos135828802zoos

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 Limit298723400.95331345.2
3Display Results3403400.0804250.0
 (SQL Overall)1786913401.109161128.0
 
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.