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 “occur” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

285 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
occur913732(None) 
occurs10136551occurs
coccus979282coccus
concur10411102concur
cur56841982__cur
incur72212252incur
occult1038432occult
occupy1543152occupy
ocher104516102ocher
ocker113915752ocker
odour64710492odour
our36042892o__ur
recur74116842recur
reoccur1143352reoccur
scaur75814902scaur
scour75315532scour
soccer1038542soccer
accord1178843accord
accrue1035823accrue
accurst1146243accurst
accuse103411033accuse
accuser11347933accuser
actor71116083actor
amour75014853amour
arcus76918863arcus
ascus75013583ascus
augur64311213augur
blur66020533_blur
bocce114313113bocc_e
bocces123912023bocces
bocci113512713bocc_i
boccia12338793boccia
boccie123311453boccie
boccis123911133boccis
boxcar1734753boxcar
bur55744693__bur
car59165563__car
carr65434703_carr
caul65630003_caul
cecum11611843cecum
char95132153_char
chub115516413_chub
chug105914113_chug
chum116318003_chum
churl105913883_churl
churn105113103_churn
churr104512853_churr
clour76617283clour
club85819473_club
clue65324533_clue
coca88030643coc_a
cocas95926573cocas
coccal9310223coccal
cocci82812673cocci
coccic8298943coccic
coccid102910743coccid
coccous1039003coccous
coccyx1942663coccyx
cock126332903coc_k
cocker144320393cocker
cocks135227163cocks
cockup1635713cockup
cocky164215933cocky
coco87330603coc_o
cocoa98517883cocoa
cocos95624693cocos
coder86134223coder
coir66327243_coir
color76123743color
colour85915093colour
colure8314163colure
comer95832693comer
concurs11311473concurs
conus76726533conus
cooer74831013cooer
coper95336093coper
cor59960943__cor
corer75538873corer
couch125320113couch
coup86729793_coup
court75532773_court
cover105430773cover
cower104531773cower
coyer105222843coyer
cru57129563_cru_
crud75219613_crud
cruor7310453_cruor
crura7312583_crura
crus65828483_crus
crux135415003_crux
cub76940943__cub
cud67937453__cud
cue57544183__cue
cum76440163__cum
cup76738243__cup
curb86732223__curb
curd77634983__curd
cure66149123__cure
curf97538783__curf
curl66035053__curl
curn66731893__curn
curr65429653_curr
curs65645543__curs
curt67051713__curt
cut57957663__cut
czar156013133_czar
decor84717573decor
decury1277963decury
demur8311163demur
dicer85426423dicer
docker134417653docker
doctor938993doctor
dolour75710133dolour
douceur1043113douceur
dour56330433_dour
ecru65819533ecru_
ecrus75113863ecrus
ecu56828233_ecu_
ecus65421463_ecus
escar74011993escar
facer105525053facer
femur1038683femur
ficus105015493ficus
floccus1443653floccus
flour84916453flour
focus105815883focus
forcer114917343forcer
four76226863_four
fucus105515893fucus
fur66637323__fur
gaur56723353_gaur
hiccup1554393hiccup
hocker155118563hocker
hocus104715203hocus
honour94710863honour
hour75827313_hour
ichor1039483ichor
icier74313753icier
icker114018443icker
ictus7249703ictus
incurs83012283incurs
incus73315053incus
knaur9508253knaur
knur85311973_knur
lacer75833753lacer
lemur739773lemur
locker124019423locker
lockup1434763lockup
locum94812173locum
locus74819993locus
lour45430683_lour
macer912126943macer
mocker143315443mocker
mockup1634073mockup
mohur1036513mohur
mucor94011943mucor
mucus94015743mucus
nicer74618293nicer
nocturn944653nocturn
oakum1177313oakum
oar37057953o__ar
oater55433733oater
obscure1145333obscure
oca56731733o_c_a
ocas66729633o_cas
occiput1344763occiput
occlude1263183occlude
occulter1244113occulter
occults1135123occults
occupier1442963occupier
occurred1343483occurred
ocean71212963ocean
ochers113915303ochers
ochery14319443ochery
ochre103411593ochre
ochry13346933ochry
ocicat101412813ocicat
ockers123813903ockers
ocrea73311823ocrea
octad81510653octad
octal71214723octal
octan71313483octan
octet7324063octet
octyl10136063octyl
ocular8610133ocular
oculi72010793oculi
oculus8178393oculus
odder74515393odder
odeum84610543odeum
odium83413033odium
odor55718093o_dor
odours7418253odours
offcut1444703offcut
offer114311383offer
ofter84116873ofter
ogler65917443ogler
oilcup1044253oilcup
oiler54628283oiler
older65121173older
oleum73613323oleum
omber95316443omber
omer67028393o_mer
once65423083onc_e
oncet74626543oncet
onium73115533onium
onus45826813o_nus
opium92812093opium
opus66420593o_pus
or27354733o___r
orc57034923orc__
orca65522773orc_a
orcas75918623orcas
orcin72716573orcin
orcs67025433orc_s
order65019363order
ordure756813ordure
ormer75218373ormer
osar46820953o_sar
oscula837293oscula
oscular937933oscular
oscule838193oscule
osier53518013osier
other84219103other
ottar54313993ottar
otter54423973otter
ouch95724633ouc_h
oud47439073o__ud
ours47237563o__urs
out38072153o__ut
outer55633303outer
over77227343o_ver
ovum92310173o_vum
owner84613313owner
oxcart1539523oxcart
oxter123414093oxter
oyer75927653o_yer
pacer96131613pacer
picul95015363picul
poseur8419403poseur
pour611527473_pour
pur56840553__pur
racer75233023racer
recurs83315803recurs
recut74729243recut
reoccurs1242963reoccurs
ricer74726613ricer
rocker124319573rocker
scar66434203_scar
scaup95515993scaup
scaurs85512053scaurs
schul102510413schul
scours84913593scours
scout75031453scout
scrub94914203scrub
scrum95418203scrum
scud76221283_scud
scum85924523_scum
scup84822383_scup
scurf104719323_scurf
scut65835543_scut
secure8513533secure
sieur5911893sieur
slur45525153_slur
soccers1138393soccers
soucar839323soucar
sour45935893_sour
sowcar1135863sowcar
spur65321193_spur
stour54916743stour
succor1036623succor
succour1144693succour
tocher114014913tocher
tour45530383_tour
ulcer7310753ulcer
uncurb1037043uncurb
uncurl839413uncurl
uncus74014983uncus
uncut73219173uncut
upcurl1034963upcurl
vacua10510463vacua
vicar10513863vicar
voicer113910543voicer
voyeur1232863voyeur
waur76819903_waur
your78623433_your

Search took 5 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 Filter178691836670.343520965.0
2DLD Change Limit836672854.00020916.8
3Display Results2852850.0962968.8
 (SQL Overall)1786912854.43940254.8
 
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.